MainPipe 인터페이스
Provides the managed implementation of the IDTSPipeline100 interface used to programmatically configure a data flow task.
네임스페이스: Microsoft.SqlServer.Dts.Pipeline.Wrapper
어셈블리: Microsoft.SqlServer.DTSPipelineWrap(Microsoft.SqlServer.DTSPipelineWrap.dll)
구문
‘선언
<GuidAttribute("410E91E9-2C45-487A-851A-5B3DFE747329")> _
Public Interface MainPipe _
Inherits IDTSPipeline100
‘사용 방법
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
MainPipe 유형에서 다음 멤버를 표시합니다.
속성
| 이름 | 설명 | |
|---|---|---|
.gif "공용 속성") |
AutoGenerateIDForNewObjects | Gets or sets a value that specifies whether the data flow automatically generates and sets the ID property for newly created objects. (IDTSPipeline100에서 상속됨) |
|
BLOBTempStoragePath | Gets or sets a value that specifies the file system location where Binary Large Objects (BLOBs) are temporarily written to disk. (IDTSPipeline100에서 상속됨) |
|
BufferManager | Gets the IDTSBufferManager100 object. (IDTSPipeline100에서 상속됨) |
|
BufferTempStoragePath | Gets or sets the file system path used to temporarily cache buffer data. (IDTSPipeline100에서 상속됨) |
|
ComponentMetaDataCollection | Gets the collection of data flow components in the task. (IDTSPipeline100에서 상속됨) |
|
DefaultBufferMaxRows | Gets or sets the maximum number of rows the task allows in an IDTSBuffer100 buffer. (IDTSPipeline100에서 상속됨) |
|
DefaultBufferSize | Gets or sets the default size of the IDTSBuffer100 objects created by the task. (IDTSPipeline100에서 상속됨) |
|
EnableCacheUpdate | 인프라입니다. Gets or sets whether the IDTSPipeline100 enabled the updating of cache. (IDTSPipeline100에서 상속됨) |
|
EnableDisconnectedColumns | Gets or sets a value that indicates whether the data flow task enables the disconnected columns in the main pipe. (IDTSPipeline100에서 상속됨) |
|
EngineThreads | Gets or sets the number of threads the data flow task uses. (IDTSPipeline100에서 상속됨) |
|
Events | Sets the events interface that the data flow and its components use to raise events during execution. (IDTSPipeline100에서 상속됨) |
|
IsSavingXml | 인프라입니다. Gets or sets whether the IDTSPipeline100 is saving xml. (IDTSPipeline100에서 상속됨) |
|
PathCollection | Gets the IDTSPathCollection100 collection for the data flow task. (IDTSPipeline100에서 상속됨) |
|
PersistenceCustomPropertyCollection | Gets the collection of custom properties that have the specified persistence format. (IDTSPipeline100에서 상속됨) |
|
RunInOptimizedMode | Gets or sets a value that specifies whether the data flow task runs in optimized mode. (IDTSPipeline100에서 상속됨) |
|
VariableDispenser | Sets the IDTSVariableDispenser100 used to lock variables in the package for reading and writing. (IDTSPipeline100에서 상속됨) |
맨 위로 이동
메서드
| 이름 | 설명 | |
|---|---|---|
.gif "공용 메서드") |
GetNextPasteID | Gets the next available ID that the data flow task generates. (IDTSPipeline100에서 상속됨) |
|
GetObjectByID | Retrieves an object contained in the data flow task by using the ID of the object. (IDTSPipeline100에서 상속됨) |
|
New | 인프라입니다. Specifies a new instance of IDTSPipeline100 class. (IDTSPipeline100에서 상속됨) |
|
UpdateCacheOnInputColumns | 인프라입니다. Updates the cache on input column of IDTSPipeline100. (IDTSPipeline100에서 상속됨) |
맨 위로 이동
주의
The MainPipe (displayed as the Data Flow Task in SQL Server Data Tools(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.
예
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;