Legacy DTS migration

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Scott Coleman One Orange Chip Points: 27452 More actions · Answer 1

One Orange Chip

Points: 27452

June 1, 2007 at 6:17 pm

Adam Bean One Orange Chip Points: 26631 More actions · Answer 2

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.

Sam Greene SSCertifiable Points: 5252 More actions · Answer 3

Thanks - Much appreciated. Saw that article, but wasn't sure it would apply to 2005.