ConnectionManager.AcquireConnection Method

Article
12/03/2008

Creates an instance of the connection type.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntax

'Declaration
Public Function AcquireConnection ( _
    txn As Object _
) As Object

public Object AcquireConnection (
    Object txn
)

public:
Object^ AcquireConnection (
    Object^ txn
)

public Object AcquireConnection (
    Object txn
)

public function AcquireConnection (
    txn : Object
) : Object

Parameters

txn
The handle to a transaction type.

Return Value

An object that contains the transaction connection.

Remarks

Pass null for the transaction parameter txn when the SupportsDTCTransactions property is false. If the SupportsDTCTransactions property is true, you can pass null in the transaction parameter to indicate that the container supports transactions, but is not going to participate.

Example

The following code example shows how to add the OLE DB connection to the connection manager and acquire the connection.

// Create the package.
Package pkg = new Package();

// Add a ConnectionManager to the Connections collection.
ConnectionManager connMgr = pkg.Connections.Add("ADO.NET:OLEDB");
connMgr.Properties["RetainSameConnection"].SetValue(connMgr , true);
connMgr.ConnectionString = connStr;

// Aqcuire the connection.
object connection = connMgr.AcquireConnection(null);

' Create the package.
Dim pkg As Package =  New Package() 
 
' Add a ConnectionManager to the Connections collection.
Dim connMgr As ConnectionManager =  pkg.Connections.Add("ADO.NET:OLEDB") 
connMgr.Properties("RetainSameConnection").SetValue(connMgr , True)
connMgr.ConnectionString = connStr
 
' Aqcuire the connection.
Dim connection As Object =  connMgr.AcquireConnection(Nothing)

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms