다음을 통해 공유

  • 아티클

Connections 속성

Returns the Connections collection of existing connections defined in the package that contains the Script task.

네임스페이스:  Microsoft.SqlServer.Dts.Tasks.ScriptTask
어셈블리:  Microsoft.SqlServer.ScriptTask.dll의 Microsoft.SqlServer.ScriptTask

구문

‘선언
Public ReadOnly Property Connections As Connections
    Get
‘사용 방법
Dim instance As ScriptObjectModel
Dim value As Connections

value = instance.Connections

public Connections Connections { get; }

public:
property Connections^ Connections {
    Connections^ get ();
}

member Connections : Connections

function get Connections () : Connections

속성 값

형식: Microsoft.SqlServer.Dts.Runtime. . :: . .Connections
The Connections collection of existing connections defined in the package that contains the Script task.

주의

Use the Connections property of the Dts object in Script task code to access connection managers defined in the package.

예제

The following sample of code for use inside a Script task demonstrates how to access connection managers from within the Script task. The sample assumes that you have created and configured an ADO.NET connection manager named Test ADO.NET Connection and a Flat File connection manager named Test Flat File Connection. Note that the ADO.NET connection manager returns a SqlConnection object that you can use immediately to connect to the data source. The Flat File connection manager, on the other hand, returns only a string that contains the path and filename. You must use methods from the System.IO namespace to open and work with the flat file.

Public Sub Main()

    Dim myADONETConnection As SqlClient.SqlConnection
    myADONETConnection = _
        DirectCast(Dts.Connections("Test ADO.NET Connection").AcquireConnection(Dts.Transaction), _
        SqlClient.SqlConnection)
    MsgBox(myADONETConnection.ConnectionString, _
        MsgBoxStyle.Information, "ADO.NET Connection")

    Dim myFlatFileConnection As String
    myFlatFileConnection = _
        DirectCast(Dts.Connections("Test Flat File Connection").AcquireConnection(Dts.Transaction), _
        String)
    MsgBox(myFlatFileConnection, MsgBoxStyle.Information, "Flat File Connection")

    Dts.TaskResult = ScriptResults.Success

End Sub