Modify a deployed SSIS package saved in the Integration Services Catalog

I have a packages deployed to the Integration Services Catalog in SQL 2012.  Is there a way to modify the package or view the deployed package using BIDS?  We have a scenario that we need to see how the package was designed for troubleshooting purpose.

May 30th, 2012 9:00pm

You need to export it to the file system as a .dtsx file, then open in SSDT/VS2010
Free Windows Admin Tool Kit Click here and download it now
May 30th, 2012 9:03pm

Export using SSMS and open the same on the BIDS, modify and redeploy

May 31st, 2012 7:02am

Since my packages are saved in the SSIS Catalog, the Export option is only availabe at the project level.  If I try to export the project, it can only be saved as an ispac file which is a deployment file.  I can not use SSDT to open the ispac file or import packages from the ispac file.  It seems to me the ispac file is for deployment only.  Any other thoughs on this?
Free Windows Admin Tool Kit Click here and download it now
May 31st, 2012 5:15pm

You can import it using the import Project wizard.  Either straight out of the catalog or from an ispac file

http://msdn.microsoft.com/en-us/library/ff929153.aspx

May 31st, 2012 5:24pm

Well its simple:

  1. export ispac file (Project deployment file),
  2. rename its suffix to .zip
  3. Extract zip file and enjoy
Free Windows Admin Tool Kit Click here and download it now
November 26th, 2012 9:43pm

Hi Chung,

Below article explaining how to edit the packages that are deployed to Catalog in ssis 2012. This Question don't have any suggestion to edit packages in catalog. Hence, i am just adding a url that will solve this problem.

http://www.mssqlgirl.com/editing-published-ssis-package-in-sql-server-2012.html

September 10th, 2015 3:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics