Options

Trouble using MSI Custom Action to call SQL Package exe

dbaerdbaer Posts: 2
edited May 20, 2008 4:15AM in SQL Packager Previous Versions
I am using Wise Installer Editor. I create a custom action to call sqlpackage executable. I get the following error.

Error:
File or assembly name xxx.exe, or one of its dependencies, was not found.

I can run this executable from the command line and it works fine.

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi,

    The problem could be that the MSI is saving the package to a temporary file and running it from there. Packages can't be renamed because the resources inside will no longer be named the same as the executable. There is a workaround to change the Packager code template so that the name of the resource is generated dynamically based on the assembly name. Please see here.
Sign In or Register to comment.