question

Chris 2 avatar image
Chris 2 asked

Script to deploy SQL 2012 SSIS

Hi, Windows 2008R2 and SQL 2012, script to deploy SSIS to Integraion Services Catalogs. Used to be in SQL 2005, I was able to DTUTIL /FILE SourceFolder\*.dtsx /Copy SQL; SSISPackage /QUIET deploy SSIS to MSDB. SQL 2012, I need to deploy SSIS to folder under Services Catelog. How do you do that in script? Thanks. Chris
sql2012
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Venkataraman avatar image
Venkataraman answered
You can use isdeploymentwizard.exe for script based deployment. Refer to http://sqlmag.com/sql-server-integration-services/ssis-deployment-sql-server-2012 for more information
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.