Deploy SSIS .ISPAC to SQL Server Catalog uisng Bamboo

[Su K]

I am trying to set up Bamboo for CI/CD of my SSIS Packages to Catalog on the SQL Server 2017. Any ideas?

I tried using MSBuild but I get an error stating bin/Development folder is not found.

[Ronnie Hicks]

Unfortunately SSIS projects are not MSBuild projects. This results in a false positive when you run them through MSBuild as MSBuild reports success since it didn't fail (it did nothing to fail against).

The accepted method to handle SSIS deployments is to use devenv (Visual Studio) with the appropriate packages installed on the deployment agent. Depending on the version of VS on the agent will depend on what packages you need. Replicate the environment setup of your local machine on the agent and you should be good.