Connection Object

DTS Programming

DTS Programming

Connection Object

The Connection object contains information about connections to data sources through OLE DB service providers. Connection objects allow connection pooling and reuse for connections within a package so that only one connection must be established for multiple steps or tasks.

Properties
Catalog Property InUse Property
Connected Property LastOwnerTaskName Property
ConnectImmediate Property Name Property
ConnectionProperties Property Parent Property
ConnectionTimeout Property Password Property
DataSource Property ProviderID Property
Description Property Reusable Property
ID Property UserID Property
InTransaction Property  
Methods
AcquireConnection Method ReleaseConnection Method

Remarks

The Connection object is compatible with Microsoft® SQL Server™ version 7.0. For more information about an extended version of this object, see Connection2 Object

See Also

Connections Collection

Creating DTS Package Objects and Connections