Azure DevOps, Git, and SSIS

After a couple false starts, I was able to live-stream one way to use Azure DevOps with Git to source-control the contents of an SSIS Catalog folder – including SSIS Catalog Folder, Projects, Packages, Environments, Environment Variables, Configured Literals, References, and Reference Mappings.

In the video, I create an Azure DevOps project configured to use Git version control. I connect to the project using Visual Studio, and use the VS Team Explorer to clone the Git repository to a local repo directory.

I use SSIS Catalog Compare to generate scripts and an SCCPAC file – which is an extension I made up to support a compressed file containing all the scripted contents of an SSIS Catalog folder in a single file (and then I built the SCCPAC Deployment Wizard to unpack the compressed file and deploy the contents in dependency order).

I use Visual Studio’s Team Explorer to commit and push the SCCPAC file to the team project’s Git repo on Azure DevOps.

All in 8-ish minutes. Not too shabby.

In reviewing the video, I notice the screen sharing does not start until 3:16. It’s not too difficult to figure out what I did in creating the Azure DevOps project before then – and you missed some slides. I’m going to leave it as is.

There are two types of developers in the world: Those who use source control, and those who will.

Use source control. Future You will thank you.


Andy Leonard

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, Azure Data Factory, SSIS, and Biml guy. I was cloud before cloud was cool. :{>


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.