DTS Programming
Connections Collection
The Connections collection is a group of Connection objects containing information about connections to OLE DB service providers. This collection allows connection pooling and reuse across steps and tasks in a DTS package.
Applies To
| Package Object | Package2 Object |
Properties
| Count Property | Parent Property |
Methods
| Add Method | Item Method |
| BeginAcquireMultipleConnections Method | New (ID) Method |
| EndAcquireMultipleConnections Method | NewDataLink Method |
| Insert Method |
Remarks
When implementing a custom task that must acquire more than one connection, do the following to avoid deadlocks:
- Call BeginAcquireMultipleConnections.
- For each connection to be acquired:
- Verify that connection.InUse is FALSE.
- Call connection.AcquireConnection.
- Verify that connection.InUse is FALSE.
- Call EndAcquireMultipleConnections.
Prototype (C/C++)
HRESULT GetConnections(IDTSConnections **pRetVal);