Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot find property in DTS object model

Status
Not open for further replies.

Hablaras

Programmer
Oct 10, 2003
22
NL
I cannot find a certain property in the DTS object model:

"always read properties from UDL file" which can be found on the property tab of a UDL connection in a DTS package.

My guess is it would be in one of the following objects:

DTS.Connection2
DTS.OleDBProperty2

But I cannot pinpoint which one it...
 
addendum:

A dirty way to check if the property is set is by examining the

DTS.Connection2.UseDSL
DTS.Connection2.UDLPath

properties.

If the property is set to FALSE:
UseDSL = -1
UDLPath = ""

if TRUE:
UseDSL = -1
UDLPath = <a path here>

This is because if the property is not set the UDLPath is cleared by the DTS designer after closing the property dialog box.

So I guess there is no separate property for it...
 
A UDL is a type of connection known as a "Microsoft Data Link". It is one of the connection object found in the DTS Designer.

I would beleive it to be the "DTS.Connection2.UDLPath" object you listed.

Thanks

J. Kusch
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top