Search code examples
sql-server-2008etlssis-2008

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

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?

Solution

  • 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