Monday, October 26, 2015

Published SSIS Package in SQL Server 2012

What happened to the export SSIS package?

Going from 2008R2 to 2012, SSIS packages began using the project deployment model.

The quick way to get a copy of the SSIS package out of SQL is to run SQL Server Management Studio as Administrator and expand the tree:

"Integration Services Catalogs" -> SSISDB -> ProjectFolderName -> Projects -> ProjectName

Then right-click the ProjectName and select "Export..."

Save and remember the name and path you save the *.ispac file.

Rename the ispac file with *.zip

Then can unzip the file.

No comments:

Post a Comment