Run SQL script, then run EXE, then run another SQL script

[AnnieKelly]

Hello.

I am new to InstallShield and developing my first MSI project. I have a situation where I need to drop foreign keys in the user's database, then use Microsoft's BCP utility to insert data to the database, then I need to add the foreign keys back. Is there any way to sequence the project so that I can run the first SQL script, then launch an executable for the BCP, then run the second SQL script?

Thanks,
Annie

[hidenori]

If you are using the SQL Scripts view to execute your SQL scripts, there is no good way to handle it. You may want to consider using the BULK INSERT (Transact-SQL) statement instead of the BCP utility.

[AnnieKelly]

That may work for me. I'll give it a try.

Thank you.
Annie