Interface MainPipe

Article
04/27/2013

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

Espace de noms : Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly : Microsoft.SqlServer.DTSPipelineWrap (en Microsoft.SqlServer.DTSPipelineWrap.dll)

Syntaxe

'Déclaration
<GuidAttribute("410E91E9-2C45-487A-851A-5B3DFE747329")> _
Public Interface MainPipe _
    Inherits IDTSPipeline100
'Utilisation
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

Le type MainPipe expose les membres suivants.

Propriétés

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

Haut de la page

Méthodes

	Nom	Description
	GetNextPasteID	Gets the next available ID that the data flow task generates. (hérité de IDTSPipeline100.)
	GetObjectByID	Retrieves an object contained in the data flow task by using the ID of the object. (hérité de IDTSPipeline100.)
	New	Infrastructure. Specifies a new instance of IDTSPipeline100 class. (hérité de IDTSPipeline100.)
	UpdateCacheOnInputColumns	Infrastructure. Updates the cache on input column of IDTSPipeline100. (hérité de IDTSPipeline100.)

Haut de la page

Notes

The MainPipe (displayed as the Data Flow Task in Outils de données SQL Server (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.

Exemples

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;

Voir aussi

Référence

Espace de noms Microsoft.SqlServer.Dts.Pipeline.Wrapper

Partager via