Поделиться через


Метод ConnectionManager.AcquireConnection

Creates an instance of the connection type.

Пространство имен:  Microsoft.SqlServer.Dts.Runtime
Сборка:  Microsoft.SqlServer.ManagedDTS (в Microsoft.SqlServer.ManagedDTS.dll)

Синтаксис

'Декларация
Public Function AcquireConnection ( _
    txn As Object _
) As Object
'Применение
Dim instance As ConnectionManager 
Dim txn As Object 
Dim returnValue As Object 

returnValue = instance.AcquireConnection(txn)
public Object AcquireConnection(
    Object txn
)
public:
Object^ AcquireConnection(
    Object^ txn
)
member AcquireConnection : 
        txn:Object -> Object
public function AcquireConnection(
    txn : Object
) : Object

Параметры

Возвращаемое значение

Тип: System.Object
An object that contains the transaction connection.

Замечания

Pass nullпустая ссылка (Nothing в Visual Basic) for the transaction parameter txn when the SupportsDTCTransactions property is false. If the SupportsDTCTransactions property is true, you can pass nullпустая ссылка (Nothing в Visual Basic) in the transaction parameter to indicate that the container supports transactions, but is not going to participate.

Примеры

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)

См. также

Справочник

ConnectionManager Класс

Пространство имен Microsoft.SqlServer.Dts.Runtime