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
매개 변수
- txn
유형: System.Object
The handle to a transaction type.
반환 값
유형: System.Object
An object that contains the transaction connection.
주의
Pass nullnull 참조(Visual Basic에서는 Nothing) for the transaction parameter txn when the SupportsDTCTransactions property is false. If the SupportsDTCTransactions property is true, you can pass nullnull 참조(Visual Basic에서는 Nothing) 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)