IDTSRuntimeConnection100.ConnectionManager Propiedad

Definición

Espacio de nombres:

Microsoft.SqlServer.Dts.Pipeline.Wrapper.Sql2012

Ensamblado:

Microsoft.SqlServer.DTSPipelineWrap.dll

public:
 property Microsoft::SqlServer::Dts::Runtime::Wrapper::Sql2012::IDTSConnectionManager100 ^ ConnectionManager { Microsoft::SqlServer::Dts::Runtime::Wrapper::Sql2012::IDTSConnectionManager100 ^ get(); void set(Microsoft::SqlServer::Dts::Runtime::Wrapper::Sql2012::IDTSConnectionManager100 ^ value); };

[System.Runtime.InteropServices.DispId(102)]
public Microsoft.SqlServer.Dts.Runtime.Wrapper.Sql2012.IDTSConnectionManager100 ConnectionManager { [System.Runtime.InteropServices.DispId(102)] get; [System.Runtime.InteropServices.DispId(102)] set; }

[<System.Runtime.InteropServices.DispId(102)>]
[<get: System.Runtime.InteropServices.DispId(102)>]
[<set: System.Runtime.InteropServices.DispId(102)>]
member this.ConnectionManager : Microsoft.SqlServer.Dts.Runtime.Wrapper.Sql2012.IDTSConnectionManager100 with get, set

Public Property ConnectionManager As IDTSConnectionManager100

Valor de propiedad

IDTSConnectionManager100

El IDTSConnectionManager100 del componente.

Atributos

DispIdAttribute

Ejemplos

' TODO: Replace the path to the package with a valid path.  
Dim package As String = "c:\Package.dtsx"   

' Create the application and load the package.  
Dim a As Application = New Application   
Dim p As Package = a.LoadPackage(package, Nothing)   

' Walk the Executables collection looking for data flow tasks.  
For Each e As Executable In p.Executables   
 Dim mp As MainPipe = CType(CType(e, TaskHost).InnerObject, MainPipe)   
 If Not (e Is Nothing) Then   
   ' Walk the components.  
   For Each md As IDTSComponentMetaData100 In mp.ComponentMetaDataCollection   
     ' Walk the RuntimeConnectionCollection.  
     For Each rc As IDTSRuntimeConnection100 In md.RuntimeConnectionCollection   
       ' Check to see whether the package's connections collection    
       '  contains the Connectionmanager stored in the RuntimeConnection.  
       If p.Connections.Contains(rc.ConnectionManagerID) Then   
         rc.ConnectionManager = DtsConvert.ToConnectionManager100(p.Connections(rc.ConnectionManagerID))   
       Else   
         Console.WriteLine("The ConnectionManager " + rc.ConnectionManagerID + " was not found in the Package's Connections collection.")   
       End If   
     Next   
   Next   
 End If   
Next  

// TODO: Replace the path to the package with a valid path.  
string package = @"c:\Package.dtsx";  

// Create the application and load the package.  
Application a = new Application();  
Package p = a.LoadPackage( package , null );  

// Walk the Executables collection looking for data flow tasks.  
foreach (Executable e in p.Executables)  
{  
    MainPipe mp = ((TaskHost)e).InnerObject as MainPipe;  
    if( e != null )  
    {  
        // Walk the components.  
        foreach( IDTSComponentMetaData100 md in mp.ComponentMetaDataCollection )  
        {  
            // Walk the RuntimeConnectionCollection.  
            foreach( IDTSRuntimeConnection100 rc in md.RuntimeConnectionCollection )  
            {  
                // Check to see if the package's connections collection contains the   
                // Connectionmanager stored in the RuntimeConnection.  
                if (p.Connections.Contains(rc.ConnectionManagerID))  
                    rc.ConnectionManager = DtsConvert.ToConnectionManager100(p.Connections[rc.ConnectionManagerID]);  
                else  
                    Console.WriteLine("The ConnectionManager " + rc.ConnectionManagerID + " was not found in the Package's Connections collection.");  
            }  
        }  
    }  
}  

Comentarios

La propiedad ConnectionManager contiene, o establece, una referencia a la instancia real del IDTSConnectionManager100 objeto contenido en el paquete. En tiempo de ejecución, esta referencia se establece automáticamente por el motor de ejecución SSIS usando la ConnectionManagerID propiedad para localizar la conexión en el paquete y asignar una referencia.

En el momento de diseño, SSIS Designer realiza esta asignación al cargar e inicializar un componente. Sin embargo, al cargar y editar programáticamente un componente, usando el modelo de objetos fuera del diseñador, la propiedad debe establecerse explícitamente. Los componentes no tienen la capacidad de referenciar explícitamente la conexión usando esta ConnectionManagerID propiedad porque la colección de conexiones del paquete no está expuesta a los componentes.