White paper: Deploying SQL Server Integration Services Packages For Continuous Integration And Deployment Using Visual Studio Team Foundation Server Using PowerShell

This whitepaper describes an automatic solution to deploying SQL Server Integration Services packages and projects with Visual Studio Team Foundation Server using PowerShell and T-SQL scripts.

The technique described in this paper provides a great framework for organizations practicing DevOps and development teams looking for a way to manage development and deployment of SSIS in a development/test/production environment. The paper bases the architecture of the solution on Build and Release in VSTS and TFS capabilities within Visual Studio Team Foundation Server for Continuous Integration (CI) and Deployment (CD) pipelines.