Search code examples
sqlsql-serverssisssis-2012

Is it possible to recover the SSIS packages that are deployed in SQL Server?


I have developed few SSIS packages in my local system and deployed it in to remote SQL Server. Now my local hard disk crashed. Is there a way to get back the packages that are deployed to SQL Server?

Thanks in advance


Solution

  • If you have access to the server itself, you or somebody with the appropriate permissions can login to the server that is running SQL Server Integration Services, from there you can open SSMS, connect to Integration Services, and export any package that has been deployed to that server.