Posted on Leave a comment

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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.