Source-Control SSIS Catalog Contents in Azure DevOps

Posted on Updated on by Andy LeonardCategories:Azure DevOps, DILM, SSIS Catalog, SSIS Catalog Compare

I did a thing – actually a couple things – that I’ve been dreaming about for a while.

In a couple recent blog posts – SSIS Catalog Compare Enterprise Generates SCCPAC Files and Azure DevOps, Software Development, and Git Part 4 – Command-Line with Azure DevOps – I walked through one way to source-control the contents of an SSIS Catalog in Azure DevOps.

In SSIS Catalog Compare Enterprise Generates SCCPAC Files I demonstrated how to use SSIS Catalog Compare Enterprise Edition to generate SCCPAC files, which are zip files that contain all the scripted artifacts from an SSIS Catalog folder (T-SQL script files and ISPAC files). I decided to land my SCCPAC files in git local repository folder.

In Azure DevOps, Software Development, and Git Part 4 – Command-Line with Azure DevOps I showed how to connect this same local git repository folder to Azure DevOps.

My dream? Source control the contents of an SSIS Catalog in Azure DevOps.

:{>

Andy Leonard

andyleonard.blog

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

Comments

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.