SCA and SSIS packages

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!

Corinne October 11, 2018 23:48

Comments

3 comments

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

Russell D October 15, 2018 08:31

0
Thank you!

Corinne October 15, 2018 14:00

0
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

way0utwest October 15, 2018 16:56

0

Add comment

Please sign in to leave a comment.

How can we help you today?

SCA and SSIS packages

Comments

Add comment