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

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

Print | posted on Thursday, November 8, 2012 10:05 AM

Feedback

No comments posted yet.

Your comment:





 
 

Copyright © Kevin Shyr

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski