How to change the Server in OLE db provider for sql Server 1

[Glowworm27]

Hello all,

I have a DTS package that I have been working on ,currently set to a test server. Once I am finished with the dts package, and have tested it thourghly I want to move it to the production server.

Is there a way using an active x task to change the Servername on all of the Microsoft OLE db Provider for SQL Server Connection objects to connect to the production server, and not the test server. With out doing it manualy?

I have a few dozen connection objects. and would like to do it programmaticaly?

Thanks IN advance
[Cannon]

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net?referedby=54275&cam=Tek-Tips

 

[nigelrivett]

Sure - you might be better off having a dynamic properties task to do it though.

I usually create a loader for dts packages which changes all the connections in the package at run time (either from t-sql, VB or a dts package) depending on the environment).

If you want to do it in an activex script then see

http://www.nigelrivett.net/SetDTSRunTimeValues.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Glowworm27]

PERFECT!

Just what I wanted.

Thanks
Gold Star for you!

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net?referedby=54275&cam=Tek-Tips