Written by:R Teachout
4/3/2008 3:52 PM

I found this online (can't find it again) so I'm blogging it to archive it..

Use to create a batch file to export all DTS packages from a SQL 2000 server

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

CommandLine
--------------------------------------------------------------------------------------
DTSRUN.EXE /S L30 /E /N "Import Snitz #2" /F "C:\DTSTest\Import Snitz #2.dts" /!X
DTSRUN.EXE /S L30 /E /N "Import Snitz Data" /F "C:\DTSTest\Import Snitz Data.dts" /!X
. . . .
DTSRUN.EXE /S L30 /E /N "Script" /F "C:\DTSTest\Script.dts" /!X

TrackbackPrint

Location: BlogsRamblings, Scriptlets, and more!MSSQL Scriptlets

Your name:
Title:
Comment:
Security Code Enter the code shown above in the box below
Add Comment   Cancel