Trouble using MSI Custom Action to call SQL Package exe

[dbaer]

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.

[Brian Donahue]

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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521