Viewing post 871 (of 871 total)
Create a linked server or use opendatasource and:
INSERT INTO msdb.dbo.sysdtspackages
SELECT * FROM LinkedServerNameHere.msdb.dbo.sysdtspackages
Is about the quickest and easiest way if you just want to move them over.
June 4, 2007 at 9:17 am
#710629