DTS Programming
BeginAcquireMultipleConnections Method
The BeginAcquireMultipleConnections method acquires ownership of the Connections collection's synchronization object. This is to serialize the acquisition of multiple connections by a Data Transformation Services (DTS) task.
Applies To
| Connections Collection |
Syntax
Connections.BeginAcquireMultipleConnections
| Part | Description |
|---|---|
| Connections | Expression that evaluates to a Connections collection |
Remarks
When implementing a custom task that needs to 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 BeginAcquireMultipleConnections();
See Also
Creating DTS Package Objects and Connections