EndAcquireMultipleConnections Method

DTS Programming

DTS Programming

EndAcquireMultipleConnections Method

The EndAcquireMultipleConnections method releases ownership of the Connections collection's synchronization object. This is after serializing the acquisition of multiple connections by a Data Transformation Services (DTS) task.

Applies To
Connections Collection
Syntax

Connections.EndAcquireMultipleConnections

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:

  1. Call BeginAcquireMultipleConnections.

  2. For each connection to be acquired:
    • Verify that connection.InUse is FALSE.

    • Call connection.AcquireConnection.
  3. Call EndAcquireMultipleConnections.
Prototype (C/C++)

HRESULT EndAcquireMultipleConnections();

See Also

AcquireConnection Method

BeginAcquireMultipleConnections Method

Connection Object

Creating DTS Package Objects and Connections

InUse Property