Running DOS Commands From Inside MSI
Hello, I am using Wise 5.1 and I need to run a .sql file that contains transact sql to set up a login on a sql server database. When I run the .sql file from the command line on a server I just use "isql -E -i FILENAME" and everything works fine.
How can I run a DOS command to call isql from inside the Wise installation? Under the custom actions options I only have things like Run a VBScript or Run a Program.
Run a Program forces me to have a .exe file inside the installer to run. I don't want to have to package isql.exe
If there is a simple way to run a DOS command on the host machine from the Wise Script, please let me know.
How can I run a DOS command to call isql from inside the Wise installation? Under the custom actions options I only have things like Run a VBScript or Run a Program.
Run a Program forces me to have a .exe file inside the installer to run. I don't want to have to package isql.exe
If there is a simple way to run a DOS command on the host machine from the Wise Script, please let me know.
0 Comments
[ + ] Show comments
Answers (4)
Please log in to answer
Posted by:
grimmeissen
18 years ago
Does that mean I have to put cmd.exe inside my package in order to run that command?
Posted by:
sridtech
18 years ago
hi grimmeissen,
Perform the following actions in WISE to use the command line within ur package.
* Open your WSI file in WfWI editor. Click on the "MSI Script" tab.
* Click on "Execute Immediate" sequence tab.
* Invoke the CA "Execute Program From path" with a condition "NOT Installed" after the "Install Finalize" action.
* Enter the following information on the "Details" tab for this CA:
Custom Action Name = <YOUR_CUSTOM_ACTION>
Property = %COMSPEC%
Command Line = isql -E -i FILENAME
* Compile and test MSI installation to see if action is executed.
Let me know if you have any problems.
Good Luck,
Srid
Perform the following actions in WISE to use the command line within ur package.
* Open your WSI file in WfWI editor. Click on the "MSI Script" tab.
* Click on "Execute Immediate" sequence tab.
* Invoke the CA "Execute Program From path" with a condition "NOT Installed" after the "Install Finalize" action.
* Enter the following information on the "Details" tab for this CA:
Custom Action Name = <YOUR_CUSTOM_ACTION>
Property = %COMSPEC%
Command Line = isql -E -i FILENAME
* Compile and test MSI installation to see if action is executed.
Let me know if you have any problems.
Good Luck,
Srid
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.