ConnectionManager.AcquireConnection(Object) Method

Reference

Definition

Namespace:: Microsoft.SqlServer.Dts.Runtime

Assembly:: Microsoft.SqlServer.ManagedDTS.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Creates an instance of the connection type.

public:
 System::Object ^ AcquireConnection(System::Object ^ txn);

public object AcquireConnection (object txn);

member this.AcquireConnection : obj -> obj

Public Function AcquireConnection (txn As Object) As Object

Parameters

txn: Object

The handle to a transaction type.

Returns

Object

An object that contains the transaction connection.

Examples

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)

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.

Applies to

Sdílet prostřednictvím