to include SQL files in MSI

Topics: Bindings File, Settings Management and SSO, General Questions, Getting Started/Beginner
Dec 3, 2010 at 7:50 AM

Hi.

I ahve a biztalk project and I need to include  SQL scripts file to my MSI .

 

How can i do this by using BTDF?

 

THanks ,

Maggi

Coordinator
Dec 3, 2010 at 2:06 PM

Just add the script file(s) to an AdditionalFiles ItemGroup, which will cause them to be included in the MSI.  To run the script you can use a target in your .btdfproj called CustomDeployTarget and an Exec task to call osql.exe or sqlcmd.exe from SQL Server to run the script.

Thanks,
Tom