Save all DTS packages

,

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

Rate

5 (2)

Share

Share

Rate

5 (2)