call us toll-free +1 855 855 3600
 
Home > Whitepapers > Deploying SQL Server Integration Services Packages For Continuous Integration And Deployment Using Visual Studio Team Foundation Server Using PowerShell

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

 

Author: Bill Ramos

Published: December 1, 2017

 

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.