ScriptObjectModel.Connections Property
Returns the Connections collection of existing connections defined in the package that contains the Script task.
Espacio de nombres: Microsoft.SqlServer.Dts.Tasks.ScriptTask
Ensamblado: Microsoft.SqlServer.ScriptTask (in microsoft.sqlserver.scripttask.dll)
Sintaxis
'Declaración
Public ReadOnly Property Connections As Connections
public Connections Connections { get; }
public:
property Connections^ Connections {
Connections^ get ();
}
/** @property */
public Connections get_Connections ()
public function get Connections () : Connections
Valor de propiedad
The Connections collection of existing connections defined in the package that contains the Script task.
Notas
Use the Connections property of the Dts object in Script task code to access connection managers defined in the package.
Ejemplo
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 = Dts.Results.Success
End Sub
Seguridad para subprocesos
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.
Plataformas
Plataformas de desarrollo
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Plataformas de destino
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Vea también
Referencia
ScriptObjectModel Class
ScriptObjectModel Members
Microsoft.SqlServer.Dts.Tasks.ScriptTask Namespace