Trouble using MSI Custom Action to call SQL Package exe

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

Trouble using MSI Custom Action to call SQL Package exe

Postby dbaer » Mon May 19, 2008 6:44 pm

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.
dbaer
 
Posts: 1
Joined: Mon May 19, 2008 6:35 pm

Postby Brian Donahue » Tue May 20, 2008 9:15 am

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
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests