Save all DTS packages

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