MainPipeClass Clase

Definición

public ref class MainPipeClass : Microsoft::SqlServer::Dts::Pipeline::Wrapper::Sql2014::MainPipe
[System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)]
[System.Runtime.InteropServices.Guid("1CF081CA-677D-4561-967A-D06798F62DD6")]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)]
public class MainPipeClass : Microsoft.SqlServer.Dts.Pipeline.Wrapper.Sql2014.MainPipe
[<System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)>]
[<System.Runtime.InteropServices.Guid("1CF081CA-677D-4561-967A-D06798F62DD6")>]
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)>]
type MainPipeClass = class
    interface IDTSPipeline100
    interface MainPipe
    interface IDTSObjectModel100
Public Class MainPipeClass
Implements MainPipe
Herencia
MainPipeClass
Atributos
Implementaciones

Ejemplos

En el ejemplo de código siguiente se agrega una tarea de flujo de datos a un paquete, se agrega un componente de origen OLE DB y un componente de destino OLE DB y se establece una ruta de acceso entre los dos componentes.

using System;  
using Microsoft.SqlServer.Dts.Runtime.;  
using Microsoft.SqlServer.Dts.Pipeline.Wrapper.Sql2014;  

namespace Microsoft.Samples.SqlServer.Dts  
{  
    public class Class1  
    {  
        public static void Main(string []args)  
        {  
            // Create the package.  
            Package p = new Package();  

            // Add the data flow task.  
            MainPipe mp = ((TaskHost)p.Executables.Add("DTS.Pipeline")).InnerObject as MainPipe;  

            // Add the OLE DB source component.  
            IDTSComponentMetaData100 mdOleDbSrc = mp.ComponentMetaDataCollection.New();  
            mdOleDbSrc.ComponentClassID = "DTSAdapter.OleDbSource";  
            mdOleDbSrc.Name = "OLEDB Source";  
            CManagedComponentWrapper wrpOledbSrc = mdOleDbSrc.Instantiate();  

            // Add the OLE DB destination component.  
            IDTSComponentMetaData100 mdOleDbDest = mp.ComponentMetaDataCollection.New();  
            mdOleDbDest.ComponentClassID = "DTSAdapter.OleDbDestination";  
            mdOleDbDest.Name = "OLEDB Destination";  
            CManagedComponentWrapper wrpOledbDest = mdOleDbSrc.Instantiate();  

            // Create a path and attach the output of the source to the input of the destination.  
            IDTSPath100 path = mp.PathCollection.New();  
            path.AttachPathAndPropagateNotifications(mdOleDbSrc.OutputCollection[0], mdOleDbDest.InputCollection[0]);  
        }  
    }  
}  
Imports System   
Imports Microsoft.SqlServer.Dts.Runtime   
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper   
Namespace Microsoft.Samples.SqlServer.Dts   

 Public Class Class1   

   Public Shared Sub Main(ByVal args As String())   
     Dim p As Package = New Package   
     Dim mp As MainPipe = CType(CType(p.Executables.Add("DTS.Pipeline"), TaskHost).InnerObject, MainPipe)   
     Dim mdOleDbSrc As IDTSComponentMetaData100 = mp.ComponentMetaDataCollection.New   
     mdOleDbSrc.ComponentClassID = "DTSAdapter.OleDbSource"   
     mdOleDbSrc.Name = "OLEDB Source"   
     Dim wrpOledbSrc As CManagedComponentWrapper = mdOleDbSrc.Instantiate   
     Dim mdOleDbDest As IDTSComponentMetaData100 = mp.ComponentMetaDataCollection.New   
     mdOleDbDest.ComponentClassID = "DTSAdapter.OleDbDestination"   
     mdOleDbDest.Name = "OLEDB Destination"   
     Dim wrpOledbDest As CManagedComponentWrapper = mdOleDbSrc.Instantiate   
     Dim path As IDTSPath100 = mp.PathCollection.New   
     path.AttachPathAndPropagateNotifications(mdOleDbSrc.OutputCollection(0), mdOleDbDest.InputCollection(0))   
   End Sub   
 End Class   
End Namespace  

Comentarios

Esta clase representa la tarea de flujo de datos y se usa cuando se crea mediante programación un diseño de flujo de datos. Se crea una instancia de la clase agregando la tarea de flujo de datos a la Executables colección de .Package Los componentes se agregan a la tarea mediante la ComponentMetaDataCollection propiedad . Las conexiones se establecen entre componentes mediante la PathCollection propiedad .

Constructores

MainPipeClass()

Propiedades

AutoGenerateIDForNewObjects
BLOBTempStoragePath
BufferManager
BufferTempStoragePath
ComponentMetaDataCollection
DefaultBufferMaxRows
DefaultBufferSize
EnableCacheUpdate
EnableDisconnectedColumns
EngineThreads
Events
IDTSObjectModel100_AutoGenerateIDForNewObjects
IDTSObjectModel100_ComponentMetaDataCollection
IDTSObjectModel100_EnableCacheUpdate
IDTSObjectModel100_EnableDisconnectedColumns
IDTSObjectModel100_IsSavingXml
IDTSObjectModel100_PathCollection
IsSavingXml
PathCollection
PersistenceCustomPropertyCollection[DTSPersistenceFormat]
RunInOptimizedMode
VariableDispenser

Métodos

GetNextPasteID()
GetObjectByID(Int32)
IDTSObjectModel100_get_AutoGenerateIDForNewObjects()
IDTSObjectModel100_get_ComponentMetaDataCollection()
IDTSObjectModel100_get_EnableCacheUpdate()
IDTSObjectModel100_get_EnableDisconnectedColumns()
IDTSObjectModel100_get_IsSavingXml()
IDTSObjectModel100_get_PathCollection()
IDTSObjectModel100_GetObjectByID(Int32)
IDTSObjectModel100_New()
IDTSObjectModel100_set_AutoGenerateIDForNewObjects(Boolean)
IDTSObjectModel100_set_EnableCacheUpdate(Boolean)
IDTSObjectModel100_set_EnableDisconnectedColumns(Boolean)
IDTSObjectModel100_set_IsSavingXml(Boolean)
IDTSObjectModel100_UpdateCacheOnInputColumns()
New()
UpdateCacheOnInputColumns()

Se aplica a