Home‎ > ‎Announcements‎ > ‎

Recover SSIS Packages from a restored MSDB backup

posted Mar 21, 2013, 4:22 PM by William Yeager
I needed to recover an old version of an SSIS package that I knew was good.  The copies in BIDS was questionable.  
Find your backup of MSDB (hopefully you have one!).  
Restore it to somewhere else on the server.  
DO NOT OVERLAY MSDB!!!
Name it something else such as MSDB_Restore
DO NOT OVERLAY MSDB!!!

Extract the files using bcp then import them into version control or back into MSDB.

bcp "select cast(cast(packagedata as varbinary(max)) as varchar(max)) from yourMSDBrestore.dbo.sysssispackages 
where name = 'YourPackageName'" queryout c:\tt\YourPackageName.dtsx -Slocalhost -T -c

Hope that helps.
Comments