Geeks With Blogs
My Digital Life in Data Flow Data Warehouse, MDX, Cube, SSIS, BizTalk, SQL, XML, SSAS, SSRS, .NET

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

Posted on Thursday, November 8, 2012 10:05 AM | Back to top


Comments on this post: Deploying SSIS to Integration Services Catalog (SSISDB) via SQL Server Data Tools

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Kevin Shyr | Powered by: GeeksWithBlogs.net | Join free