Clase MainPipeClass
Adds and connects components in a data flow layout.
Jerarquía de herencia
System.Object
Microsoft.SqlServer.Dts.Pipeline.Wrapper.MainPipeClass
Espacio de nombres: Microsoft.SqlServer.Dts.Pipeline.Wrapper
Ensamblado: Microsoft.SqlServer.DTSPipelineWrap (en Microsoft.SqlServer.DTSPipelineWrap.dll)
Sintaxis
'Declaración
<ClassInterfaceAttribute(ClassInterfaceType.None)> _
<GuidAttribute("5918251B-2970-45A4-AB5F-01C3C588FE5A")> _
Public Class MainPipeClass _
Implements IDTSPipeline100, MainPipe, IDTSObjectModel100
'Uso
Dim instance As MainPipeClass
[ClassInterfaceAttribute(ClassInterfaceType.None)]
[GuidAttribute("5918251B-2970-45A4-AB5F-01C3C588FE5A")]
public class MainPipeClass : IDTSPipeline100,
MainPipe, IDTSObjectModel100
[ClassInterfaceAttribute(ClassInterfaceType::None)]
[GuidAttribute(L"5918251B-2970-45A4-AB5F-01C3C588FE5A")]
public ref class MainPipeClass : IDTSPipeline100,
MainPipe, IDTSObjectModel100
[<ClassInterfaceAttribute(ClassInterfaceType.None)>]
[<GuidAttribute("5918251B-2970-45A4-AB5F-01C3C588FE5A")>]
type MainPipeClass =
class
interface IDTSPipeline100
interface MainPipe
interface IDTSObjectModel100
end
public class MainPipeClass implements IDTSPipeline100, MainPipe, IDTSObjectModel100
El tipo MainPipeClass expone los siguientes miembros.
Constructores
| Nombre | Descripción | |
|---|---|---|
.gif "Método público") |
MainPipeClass | Initializes a new instance of the MainPipeClass. |
Arriba
Propiedades
| Nombre | Descripción | |
|---|---|---|
.gif "Propiedad pública") |
AutoGenerateIDForNewObjects | Gets or sets a value that specifies whether a data flow automatically generates and sets the ID property for newly created objects. |
|
BLOBTempStoragePath | Gets or sets a value that specifies the file system location where binary large objects (BLOBs) are temporarily written to disk. |
|
BufferManager | Gets the buffer manager for the main pipe. |
|
BufferTempStoragePath | Gets or sets the file system path used to temporarily cache buffer data. |
|
ComponentMetaDataCollection | Gets the collection of data flow components in the task. |
|
DefaultBufferMaxRows | Gets or sets the maximum number of rows the task allows in an IDTSBuffer100 buffer. |
|
DefaultBufferSize | Gets or sets the default size of the IDTSBuffer100 objects created by a task. |
|
EnableCacheUpdate | Gets or sets a value that indicates whether the data flow task enables cache updates. |
|
EnableDisconnectedColumns | Gets or sets a value that indicates whether the task enables disconnected columns. |
|
EngineThreads | Gets or sets the number of threads a data flow task uses. |
|
Events | Sets the events interface that a data flow, and the components it contains, use to raise events during execution. |
|
IDTSObjectModel100_AutoGenerateIDForNewObjects | Gets or sets a value that specifies whether a data flow automatically generates and sets the ID property for newly created objects. |
|
IDTSObjectModel100_ComponentMetaDataCollection | Gets the collection of data flow components in the task. |
|
IDTSObjectModel100_EnableCacheUpdate | Gets or sets a value that indicates whether the data flow task enables the cache updates. |
|
IDTSObjectModel100_EnableDisconnectedColumns | Gets or sets a value that indicates whether the data flow task enables the disconnected columns in the main pipe. |
|
IDTSObjectModel100_IsSavingXml | Gets or sets a value that indicates the data flow task saves in Xml format. |
|
IDTSObjectModel100_PathCollection | Gets the IDTSPathCollection100 collection for a data flow task. |
|
IsSavingXml | Gets or sets a value that indicates whether the task saves in Xml format. |
|
PathCollection | Gets the IDTSPathCollection100 collection for a data flow task. |
|
PersistenceCustomPropertyCollection | Gets the persistence format of the data flow task's custom property collection. |
|
RunInOptimizedMode | Gets or sets a value that specifies whether a data flow task runs in optimized mode. |
|
VariableDispenser | Sets the IDTSVariableDispenser100 used to lock variables in a package for reading and writing. |
Arriba
Métodos
| Nombre | Descripción | |
|---|---|---|
|
Equals | (Se hereda de Object.) |
.gif "Método protegido") |
Finalize | (Se hereda de Object.) |
|
GetHashCode | (Se hereda de Object.) |
|
GetNextPasteID | Gets the next available ID that a data flow task generates. |
|
GetObjectByID | Retrieves an object contained in a data flow task. |
|
GetType | (Se hereda de Object.) |
|
IDTSObjectModel100_GetObjectByID | Retrieves an object that is contained in a data flow task. |
|
IDTSObjectModel100_New | Resets the layout of components in a data flow task. |
|
IDTSObjectModel100_UpdateCacheOnInputColumns | Sets the data flow task to update the cache from previous version. |
|
MemberwiseClone | (Se hereda de Object.) |
|
New | Infraestructura. Creates a new instance of MainPipeClass. |
|
ToString | (Se hereda de Object.) |
|
UpdateCacheOnInputColumns | Sets the cache to upgrade from previous version. |
Arriba
Comentarios
This class represents the data flow task, and is used when programmatically building a data flow layout. An instance of the class is created by adding the data flow task to the Executables collection of a Package. Components are added to the task using the ComponentMetaDataCollection property. Connections are established between components using the PathCollection property.
Ejemplos
The following code example adds a data flow task to a package, adds an OLE DB source component and an OLE DB destination component, and establishes a path between the two components.
using System;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
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
Seguridad para subprocesos
Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.