I have defined a "Microsoft Data Link" Connection by using specified
UDL in UDL Design Sheet, I would like to retrieve the Data Source and
Inital Catalog at Data Link Properties such that I would be able to
execute my Package in different server and db.

my inital catalog and data source is in "Microsoft Data Link" under
"Ole DB Properties", How can I retrieve shcuh propertiesin VB Scipt??

Jackie

Hello lai3288 (AT) gmail (DOT) com,

If I have a UDL called "Microsoft Data Link" in my package I can retrieve
its DataSource property by doing the following.

DTSGlobalvariables.Parent.Connections("Microsoft Data Link").DataSource

Does this help?

Allan