just modify the directory and run
Recover Those Packages!
Ever need to recover a single package? Don't have local backups? Read this!!!
2001-08-16
6,855 reads
just modify the directory and run
DECLARE @TARGETDIR varchar(1000) SET @TARGETDIR = 'C:\DTSTest\' SELECT distinct 'DTSRUN.EXE /S ' + CONVERT(varchar(200), SERVERPROPERTY('servername')) + ' /E ' + ' /N ' + '"' + name + '"' + ' /F ' + '"' + @TARGETDIR + name + '.dts"' + ' /!X' FROM msdb.dbo.sysdtspackages P