Home > database >  Build Integration Services project with MSBUILD
Build Integration Services project with MSBUILD

Time:06-09

Is it possible to build the solution (to get the .ispac file) of an Integration Services Project using msbuild.exe?

I get different errors, e.g.

error MSB4067: The element <DeploymentModel> beneath element <Proj
ect> is unrecognized.

Is msbuild also for SSIS projects?

CodePudding user response:

Microsoft released standalone tools to build and deploy specifically to be used in devops pipelines but can be used anywhere

Please see the official documentation on Standalone SQL Server Integration Service (SSIS) DevOps Tools

After installing it you can call it like below to build

SSISBuild.exe -p:"D:\SSISProjectPath\MyHelloWorld\MyHelloWorld.dtproj" -o:"D:\MySpecialOutputFolder\ssis\build" 

And then deploy it

SSISDeploy.exe -s:D:\MySpecialOutputFolder\ssis\build\MyHelloWorld.ispac -d:catalog;/SSISDB/destfolder;myssisserver -at:win
  • Related