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: 446
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.
© Geeks with Blogs or respective owner