다음을 통해 공유

ScriptComponent.AcquireConnections 메서드

  • 아티클

Obtains a connection or connection information by using a connection manager.

네임스페이스:  Microsoft.SqlServer.Dts.Pipeline
어셈블리:  Microsoft.SqlServer.TxScript(Microsoft.SqlServer.TxScript.dll)

구문

‘선언
Public Overridable Sub AcquireConnections ( _
    Transaction As Object _
)
‘사용 방법
Dim instance As ScriptComponent 
Dim Transaction As Object

instance.AcquireConnections(Transaction)

public virtual void AcquireConnections(
    Object Transaction
)

public:
virtual void AcquireConnections(
    Object^ Transaction
)

abstract AcquireConnections : 
        Transaction:Object -> unit  
override AcquireConnections : 
        Transaction:Object -> unit

public function AcquireConnections(
    Transaction : Object
)

매개 변수

  • Transaction
    유형: System.Object
    The transaction object to associate with the connection.

주의

The Script component developer does not use the ScriptComponent class directly, but indirectly, by coding the methods and properties of the ScriptMain class, which inherits from ScriptComponent through the UserComponent class.

The developer can override the AcquireConnections method in the ScriptMain class to connect to an external data source from a source or destination component.

예

The following code sample demonstrates how the Script component developer might obtain a SqlConnection by using the AcquireConnections method. For more information, see 스크립트 구성 요소 개체 모델 이해.

    Dim connMgr As IDTSConnectionManager100
    Dim sqlConn As SqlConnection

    Public Overrides Sub AcquireConnections(ByVal Transaction As Object)

        connMgr = Me.Connections.MyADONETConnection
        sqlConn = CType(connMgr.AcquireConnection(Nothing), SqlConnection)

    End Sub

참고 항목

참조

ScriptComponent 클래스

Microsoft.SqlServer.Dts.Pipeline 네임스페이스