Thursday, December 24, 2009

Coping SSIS Jobs to different Server

SELECT 'dtutil /COPY SQL;' + NAME + ' /SourceS servera /SQL ' + NAME + ' /DestS serverb
FROM msdb.dbo.sysdtspackages90

No comments: