Scripting SSIS Deployments

Chad Miller shows us how to script SSIS deployments via Powershell.  One of the two depressing things about integrating SSIS packages into an automated build process was just how difficult it was to automate deployment (the other was that source control is effectively meaningless when it comes to determining changes).  Chad’s solution is a pretty good one, and something I hadn’t really seen elsewhere.

Advertisements