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.
Modify a deployed SSIS package saved in the Integration Services Catalog
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
May 31st, 2012 5:24pm
Well its simple:
- export ispac file (Project deployment file),
- rename its suffix to .zip
- 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