通过

ScriptComponent.AcquireConnections Method

  • 项目

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

命名空间: Microsoft.SqlServer.Dts.Pipeline
程序集: Microsoft.SqlServer.TxScript (in microsoft.sqlserver.txscript.dll)

语法

声明
Public Overridable Sub AcquireConnections ( _
    Transaction As Object _
)

public virtual void AcquireConnections (
    Object Transaction
)

public:
virtual void AcquireConnections (
    Object^ Transaction
)

public void AcquireConnections (
    Object Transaction
)

public function AcquireConnections (
    Transaction : Object
)

参数

  • Transaction
    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 Understanding the Script Component Object Model.

    Dim connMgr As IDTSConnectionManager90
    Dim sqlConn As SqlConnection

    Public Overrides Sub AcquireConnections(ByVal Transaction As Object)

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

    End Sub

线程安全

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

ScriptComponent Class
ScriptComponent Members
Microsoft.SqlServer.Dts.Pipeline Namespace