Freigeben über


MainPipe-Schnittstelle

Provides the managed implementation of the IDTSPipeline100 interface used to programmatically configure a data flow task.

Namespace:  Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly:  Microsoft.SqlServer.DTSPipelineWrap (in Microsoft.SqlServer.DTSPipelineWrap.dll)

Syntax

'Declaration
<GuidAttribute("410E91E9-2C45-487A-851A-5B3DFE747329")> _
Public Interface MainPipe _
    Inherits IDTSPipeline100
'Usage
Dim instance As MainPipe
[GuidAttribute("410E91E9-2C45-487A-851A-5B3DFE747329")]
public interface MainPipe : IDTSPipeline100
[GuidAttribute(L"410E91E9-2C45-487A-851A-5B3DFE747329")]
public interface class MainPipe : IDTSPipeline100
[<GuidAttribute("410E91E9-2C45-487A-851A-5B3DFE747329")>]
type MainPipe =  
    interface 
        interface IDTSPipeline100 
    end
public interface MainPipe extends IDTSPipeline100

Der MainPipe-Typ macht folgende Elemente verfügbar.

Eigenschaften

  Name Beschreibung
Öffentliche Eigenschaft AutoGenerateIDForNewObjects Gets or sets a value that specifies whether the data flow automatically generates and sets the ID property for newly created objects. (Geerbt von IDTSPipeline100.)
Öffentliche Eigenschaft BLOBTempStoragePath Gets or sets a value that specifies the file system location where Binary Large Objects (BLOBs) are temporarily written to disk. (Geerbt von IDTSPipeline100.)
Öffentliche Eigenschaft BufferManager Gets the IDTSBufferManager100 object. (Geerbt von IDTSPipeline100.)
Öffentliche Eigenschaft BufferTempStoragePath Gets or sets the file system path used to temporarily cache buffer data. (Geerbt von IDTSPipeline100.)
Öffentliche Eigenschaft ComponentMetaDataCollection Gets the collection of data flow components in the task. (Geerbt von IDTSPipeline100.)
Öffentliche Eigenschaft DefaultBufferMaxRows Gets or sets the maximum number of rows the task allows in an IDTSBuffer100 buffer. (Geerbt von IDTSPipeline100.)
Öffentliche Eigenschaft DefaultBufferSize Gets or sets the default size of the IDTSBuffer100 objects created by the task. (Geerbt von IDTSPipeline100.)
Öffentliche Eigenschaft EnableCacheUpdate Infrastruktur Gets or sets whether the IDTSPipeline100 enabled the updating of cache. (Geerbt von IDTSPipeline100.)
Öffentliche Eigenschaft EnableDisconnectedColumns Gets or sets a value that indicates whether the data flow task enables the disconnected columns in the main pipe. (Geerbt von IDTSPipeline100.)
Öffentliche Eigenschaft EngineThreads Gets or sets the number of threads the data flow task uses. (Geerbt von IDTSPipeline100.)
Öffentliche Eigenschaft Events Sets the events interface that the data flow and its components use to raise events during execution. (Geerbt von IDTSPipeline100.)
Öffentliche Eigenschaft IsSavingXml Infrastruktur Gets or sets whether the IDTSPipeline100 is saving xml. (Geerbt von IDTSPipeline100.)
Öffentliche Eigenschaft PathCollection Gets the IDTSPathCollection100 collection for the data flow task. (Geerbt von IDTSPipeline100.)
Öffentliche Eigenschaft PersistenceCustomPropertyCollection Gets the collection of custom properties that have the specified persistence format. (Geerbt von IDTSPipeline100.)
Öffentliche Eigenschaft RunInOptimizedMode Gets or sets a value that specifies whether the data flow task runs in optimized mode. (Geerbt von IDTSPipeline100.)
Öffentliche Eigenschaft VariableDispenser Sets the IDTSVariableDispenser100 used to lock variables in the package for reading and writing. (Geerbt von IDTSPipeline100.)

Zum Anfang

Methoden

  Name Beschreibung
Öffentliche Methode GetNextPasteID Gets the next available ID that the data flow task generates. (Geerbt von IDTSPipeline100.)
Öffentliche Methode GetObjectByID Retrieves an object contained in the data flow task by using the ID of the object. (Geerbt von IDTSPipeline100.)
Öffentliche Methode New Infrastruktur Specifies a new instance of IDTSPipeline100 class. (Geerbt von IDTSPipeline100.)
Öffentliche Methode UpdateCacheOnInputColumns Infrastruktur Updates the cache on input column of IDTSPipeline100. (Geerbt von IDTSPipeline100.)

Zum Anfang

Hinweise

The MainPipe (displayed as the Data Flow Task in SQL Server-Datentools (SSDT)) is the managed implementation of the IDTSPipeline100 COM interface. It is the interface used from managed code when programmatically creating or modifying a data flow task in a Package. For an overview of the methods and properties available to this object, see the MainPipeClass documentation.

Beispiele

The following code example adds the MainPipe object to a Package and retrieves the MainPipe using the InnerObject property of the TaskHost.

Package p = new Package();
Executable e = p.Executables.Add("DTS.Pipeline.1");
TaskHost thMainPipe = e as TaskHost;
MainPipe dataFlowTask = thMainPipe.InnerObject as MainPipe;

Siehe auch

Verweis

Microsoft.SqlServer.Dts.Pipeline.Wrapper-Namespace