how to migrate dts and it's job -- sql server dts

fred
8/5/2006 10:06:02 AM

After intensive search, i could only found transferring dts.sysdtspackages
system table entry could transfer dts from one server to another...

Currently i face 2 main questions:

1. After those packages transferred, connection setting still pointing to
old server ( some are sql , some are unc path for text/csv file and some are
odbc pointing to mainframe ).

How can i automated change all this connection pointing to new server?

I've tried using activex (dts.packages) looping thru all properties and
trying to change it and save back to server, but it's seem this method
distroy the whole structure.

2. All those packages have scheduled job to run, how or can i migrate these
jobs together with dts?

Allan Mitchell
8/7/2006 6:47:18 PM

You cannot really automate the change. You should build in this
functioanlity from the word go which is how we use the Dynamic Properties
task.

You can script out the jobs and change some of the text in the script. I
always have jobs saved as script files for this very reason. There is also
a Transfer Jobs task in DTS

--

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

[quoted text, click to view]

sql server dts : how to migrate dts and it's job