Koos van Strien gives us three methods for building SSIS projects:
First things first
First, set your expectations: you won’t create a one-size-fits-all build task that will build all your project types. Instead, you will split up your builds by project type – essentially just as described in Continuous Integration for BI in VSTS: Splitting Build Steps by Project Type.
Building SSIS projects
With folder and solution structure in place, we’ll explore three ways to build SSIS projects:
-
SSISBuild / SSISDeploy
-
Just-for-build SSIS projects
-
“Build” inside PowerShell
It’s a good post, so check it out if you’re looking at automating SSIS project deployments.