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.