Export deployed SSIS package from SQL Server 2008 to Visual Studio 2008

655 Views Asked by At

There are ETL Packages that have been deployed to SQL 2008. I want to export these back to SSIS 2008 to update the package. For some reason it is not working. Any idea on how I can do this?

1

There are 1 best solutions below

2
Lukasz Szozda On BEST ANSWER

You could export it from SSQL Server:

SSMS: Integration Services Catalogs -> SSISDB -> Project -> Right click on project -> Export -> Save the ispac file

Visual Studio: New -> Project -> Integration Services Import Project Wizard -> Select Project deployment file -> use file from step 1