cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
mayurbirari
Level 5

How to control execution of SQL scripts?

I have multiple SQL scripts in the SQL scripts view. I want to execute only some of the SQL scripts based on the user input. How can I do it? I am working in INstallscript MSI project and using IS 2008 premier edition.

Thank you.
Labels (1)
0 Kudos
3 Replies
thepeter
Level 7

you can set the scripts to execute by moving them to components that are being installed based on user input.
0 Kudos
mayurbirari
Level 5

Thanks Peter.
That's a great idea.
0 Kudos
TheTraveler
Level 8

Hello,

Here is a link that may also give you some ideas. I have created a library of functions using ADO objects within install shield (IS). I can execute SQL files, run queries versus the database to get data, and if the SQL errors, I can also get the error message from the SQL server. If you would like to know more, please let me know.
0 Kudos