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 | |
|---|---|---|
.gif "Ö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.) |
|
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.) |
|
BufferManager | Gets the IDTSBufferManager100 object. (Geerbt von IDTSPipeline100.) |
|
BufferTempStoragePath | Gets or sets the file system path used to temporarily cache buffer data. (Geerbt von IDTSPipeline100.) |
|
ComponentMetaDataCollection | Gets the collection of data flow components in the task. (Geerbt von IDTSPipeline100.) |
|
DefaultBufferMaxRows | Gets or sets the maximum number of rows the task allows in an IDTSBuffer100 buffer. (Geerbt von IDTSPipeline100.) |
|
DefaultBufferSize | Gets or sets the default size of the IDTSBuffer100 objects created by the task. (Geerbt von IDTSPipeline100.) |
|
EnableCacheUpdate | Infrastruktur Gets or sets whether the IDTSPipeline100 enabled the updating of cache. (Geerbt von IDTSPipeline100.) |
|
EnableDisconnectedColumns | Gets or sets a value that indicates whether the data flow task enables the disconnected columns in the main pipe. (Geerbt von IDTSPipeline100.) |
|
EngineThreads | Gets or sets the number of threads the data flow task uses. (Geerbt von IDTSPipeline100.) |
|
Events | Sets the events interface that the data flow and its components use to raise events during execution. (Geerbt von IDTSPipeline100.) |
|
IsSavingXml | Infrastruktur Gets or sets whether the IDTSPipeline100 is saving xml. (Geerbt von IDTSPipeline100.) |
|
PathCollection | Gets the IDTSPathCollection100 collection for the data flow task. (Geerbt von IDTSPipeline100.) |
|
PersistenceCustomPropertyCollection | Gets the collection of custom properties that have the specified persistence format. (Geerbt von IDTSPipeline100.) |
|
RunInOptimizedMode | Gets or sets a value that specifies whether the data flow task runs in optimized mode. (Geerbt von IDTSPipeline100.) |
|
VariableDispenser | Sets the IDTSVariableDispenser100 used to lock variables in the package for reading and writing. (Geerbt von IDTSPipeline100.) |
Zum Anfang
Methoden
| Name | Beschreibung | |
|---|---|---|
.gif "Öffentliche Methode") |
GetNextPasteID | Gets the next available ID that the data flow task generates. (Geerbt von IDTSPipeline100.) |
|
GetObjectByID | Retrieves an object contained in the data flow task by using the ID of the object. (Geerbt von IDTSPipeline100.) |
|
New | Infrastruktur Specifies a new instance of IDTSPipeline100 class. (Geerbt von IDTSPipeline100.) |
|
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;