Saturday, September 24, 2005

Microsoft SQL Server - Programmatically Save DTS Packages to Files - SQLTeam.com

Microsoft SQL Server - Programmatically Save DTS Packages to Files - SQLTeam.com: "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"

No comments: