Condividi tramite

  • Articolo

Metodo AcquireConnections

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

Spazio dei nomi:  Microsoft.SqlServer.Dts.Pipeline
Assembly:  Microsoft.SqlServer.TxScript (in Microsoft.SqlServer.TxScript.dll)

Sintassi

'Dichiarazione
Public Overridable Sub AcquireConnections ( _
    Transaction As Object _
)
'Utilizzo
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
)

Parametri

Osservazioni

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.

Esempi

The following code sample demonstrates how the Script component developer might obtain a SqlConnection by using the AcquireConnections method. For more information, see Informazioni sul modello di oggetti del componente script.

    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