SCA and SSIS packages

Corinne · October 11, 2018 11:48PM

We have been using SCA for our db changes/migrations and it has worked beautifully as expected.
Now we have a need to source control our numerous SSIS packages in Azure DevOps (formerly VSTS) and automate their deployment throught SCA project. Is there any documentation on how this can be done? Thank you!

Russell D · October 15, 2018 8:31AM

SQL Change Automation only supports DB objects at the moment I'm afraid, and doesn't support SSIS packages.

Corinne · October 15, 2018 2:00PM

Thank you!

way0utwest · October 15, 2018 4:56PM

You can use cmd line deployment with SSIS: https://docs.microsoft.com/en-us/sql/integration-services/ssis-quickstart-deploy-cmdline?view=sql-server-2017

However, if you want more tools, like testing, I'd look at Pragmatic works tools here.There also are a few extensions in the marketplace

SCA and SSIS packages

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk