Deploying SSIS to Integration Services Catalog (SSISDB) via SQL Server Data Tools

Posted by Kevin Shyr on Geeks with Blogs See other posts from Geeks with Blogs or by Kevin Shyr
Published on Thu, 08 Nov 2012 16:05:29 GMT Indexed on 2012/11/09 5:03 UTC
Read the original article Hit count: 399

Filed under:

There are quite a few good articles/blogs on this.  For a straight forward deployment, read this (http://www.bibits.co/post/2012/08/23/SSIS-SQL-Server-2012-Project-Deployment.aspx).  For a more dynamic and comprehensive understanding about all the different settings, read part 1 (http://www.mssqltips.com/sqlservertip/2450/ssis-package-deployment-model-in-sql-server-2012-part-1-of-2/) and part 2 (http://www.mssqltips.com/sqlservertip/2451/ssis-package-deployment-model-in-sql-server-2012-part-2-of-2/)

Microsoft official doc: http://technet.microsoft.com/en-us/library/hh213373

This only thing I would add is the following.  After your first deployment, you'll notice that the subsequent deployment skips the second step (go directly "Select Destination" and skipped "Select Source").  That's because after your initial deployment, a ispac file is created to track deployment.  If you decide to go back to "Select Source" and select SSIS catalog again, the deployment process will complete, but the packages will not be deployed.

Deploying SSIS to Integration Services Catalog (SSISDB) via SQL Server Data Tools screenshot 1

Deploying SSIS to Integration Services Catalog (SSISDB) via SQL Server Data Tools screenshot 2

Deploying SSIS to Integration Services Catalog (SSISDB) via SQL Server Data Tools screenshot 3

© Geeks with Blogs or respective owner