InstallAware

Greetings --

We need to essentially run the same MS SQL script twice when we run the install... the only difference is the first few lines of the file.

The first time it needs to run <Static Lines 1> + <Dynamic Lines 1>
The second time it needs to run <Static Lines 2> + <Dynamic Lines 1>

We know all of these at compile time. We'd like to make this as convenient as possible. One way we could do it is to have a DOS batch file that creates these, but we're wondering if there's a better way.

Thanks in advance for any advice.

I use "Write to Text File" and the from the installer I run sqlcmd or osql.exe against the script I just created.

Thanks, Jim, that makes complete sense.