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.

Tell us a little about you first

Privacy policy


eBook: Database Migration

DB Best goes well beyond other migration service providers. We take a vested interest in your migration strategy, combining innovation with an accelerated ROI that meets your business needs.  The Database Migration projects are usually part of larger application modernization efforts. DB Best realizes that no two database mig...

eBook: How the detailed modernization roadmap helped reduce the number of servers in the data center by 96%

A major American provider of global eCommerce solutions was looking for a way to upgrade their extensive data processing system. We provided them with visibility into their system and built cost-effective and highly optimized modernization roadmap using our DBMSys tool. Using our detailed instructions they can substantially c...