SCA and SSIS packages

Corinne

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

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

Corinne

Thank  you!

way0utwest

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