DTS Package - use protocol on dynamic DataSource -
09-26-2006
, 03:07 PM
Good evening from Germany!
Has anybody an idea, how I can change the servername for using the
DTS-standard-protocol (msdb database, tables sysdtspackagelog ...) on
runtime?
Yes, there are many ways to chage the value, but the changings are
recognized AFTER initialize the paket. So using global variables or
something else in the paket is "too late" for this.
I tried to set some global variables for changing the datasource
(servername) for the log, but I cant see any effect.
And the next problem on this: I have to use rundts.exe, because all
other parts, running a dts package make problems on some other places.
I don't want, that the admin my customer has to modify all packages,
after I sent them per mail to him. And I don't want to name all my
databases and serverinstances like my customer do.
So my question is: How to change the datasource for the dts-standard
protocol dynamicly on runtime, when I use dtsrun for my packages?
I hope my english is good enought to descripe my problem.
Thanks an ... Good night.
Steve |