Written by:R Teachout4/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
0 comment(s) so far...