Discussion:
How to migrate DTS packages?
(too old to reply)
Snake
2009-08-07 16:01:01 UTC
Permalink
I have 4 instances with DTS packages on each and I have to migrate
everything, including DTS packages, to a single instance. What is the best
way to migrate these packages? I can move them one-by-one but that is
moronic.

Thanks,

Michael
Snake
2009-08-07 17:13:01 UTC
Permalink
I found an answer at http://www.sqldts.com/204.aspx. The method seems to
work, but it takes a very long time to copy the rows so be patient. (10+
minutes to copy 495 rows?)
Post by Snake
I have 4 instances with DTS packages on each and I have to migrate
everything, including DTS packages, to a single instance. What is the best
way to migrate these packages? I can move them one-by-one but that is
moronic.
Thanks,
Michael
Continue reading on narkive:
Loading...