I have a load of VB script tasks that contain something like the following:

'------------Connect and open pm table

Set Cnn=CreateObject("ADODB.Connection")
cnn.Provider = "sqloledb"

Cnn.ConnectionString = "Provider=SQLOLEDB; Trusted_Connection=yes;
Server=myserver; Database=mydatabase"
Cnn.Open
..
..
..


We have a production server and a development server, and it is necessary to
manually change the connection string code when moving scripts between
servers. This does not always happen, causing production damage. Very Bad!

I would like to be able to connect using a UDL identified by a global
variable like in several other of our packages that do not use ActiveX Script
Tasks. Is it possible? How do I do it?

Thanks,

Michael

You could have a ActiveX script that opens the UDL file (its unicode BTW)
and read the connection string line and use it in the .ConnectionString
property

Paul


"Snake" <Snake (AT) discussions (DOT) microsoft.com> wrote

Thanks Paul. With my current skill-level I can not contemplate your
suggestion, but perhaps some day I will be able. It is odd that the ActiveX
object does not have scope on connection objects in the same package.

Thanks again,
Michael

"Paul Smith" wrote: