I am trying to run an executable via a custom action that relies on some temporary files to execute. For some reason, I have been unable to get the SQL Scripts to run using Advanced Installers "SQL Scripts" built in features (I'm going to post a separate thread about this if I can't solve the problem). So, I have included all the files necessary to run sqlcmd.exe and drop the tables that way. The files are an .exe, .dll, and five (5) scripts. Below is the Command Line:
"[#SQLCMD.EXE]" -U xx -P xxxxxxxxx -S [ComputerName]\SQLEXPRESS -i "[#Script1.CreateDatabaseWithFilestream.sql]" -i "[#Script2.Logins.sql]" -i "[#Script3.GX2DatabaseObjects.sql]" -i "[#Script4.DataStaticScripts.sql]" -i "[#Script5.AirCylinder.sql]"
I've verified that the files are in the Temp directory during installation and the action is done after AddResources but before FinishExecution. However, when the action tries to run, it says that it could not complete the action. I've checked the log file and the path for all the files looks right but it just doesn't run. Any ideas?