Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace

  • Article

The Microsoft.SqlServer.Dts.Pipeline.Wrapper namespace provides the classes and interfaces used to create custom Data Flow components and to automate the Data Flow task.

This assembly is a Primary Interop Assembly for DTSPipeline.dll.

Classes

  Class Description
Public class CManagedComponentWrapperClass Represents the design-time instance of a data flow component.
Public class DTSBufferManagerClass Creates and manages IDTSBuffer100 objects.
Public class MainPipeClass Adds and connects components in a data flow layout.

Structures

  Structure Description
Public structure BUFFER_WIRE_PACKET Infrastructure. Specifies the buffer wire packet of the pipeline wrapper.
Public structure DTP_BUFFCOL Contains metadata that describes the data stored in a buffer column.
Public structure tagBUFFER_WIRE_PACKET Infrastructure. Specifies the buffer wire packet for the pipeline wrapper.
Public structure tagBUFFERCOL Contains metadata that describes the data stored in a buffer column.

Interfaces

  Interface Description
Public interface CManagedComponentWrapper Configures the properties and column collections of a component.
Public interface DTSBufferManager Manages IDTSBuffer100 objects.
Public interface IDTSBLOBObject100 Used to read and write bytes to a column in an IDTSBuffer100 object.
Public interface IDTSBuffer100 Represents an in-memory, two-dimensional storage object that contains rows and columns.
Public interface IDTSBufferManager100 Creates and manages IDTSBuffer100 objects.
Public interface IDTSBufferManagerInitialize100 Infrastructure. Initializes the buffer manager for the pipeline wrapper.
Public interface IDTSBufferTapConfiguration100 Infrastructure. Represents the tap configuration for the IDTSBuffer100 object.
Public interface IDTSComponentMetaData100 Contains the definition of a data flow component, including the custom properties, inputs, outputs, and input and output columns defined on a data flow component.
Public interface IDTSComponentMetaDataCollection100 Contains a collection of IDTSComponentMetaData100 objects.
Public interface IDTSComponentView100 Allows changes to the IDTSComponentMetaData100 of a data flow component to be rolled back.
Public interface IDTSCustomProperty100 Contains custom information about an object in a data flow task.
Public interface IDTSCustomPropertyCollection100 Contains a collection of IDTSCustomProperty100 objects.
Public interface IDTSDataFileCreator100 Represents a DTS data file creator interface.
Public interface IDTSDesigntimeComponent100 Defines the design-time methods of a data flow component written in C++ and COM.
Public interface IDTSExpressionEvaluatorEx100 Infrastructure. Evaluates targeting expressions.
Public interface IDTSExternalMetadataColumn100 Represents a column from an external data source.
Public interface IDTSExternalMetadataColumnCollection100 Contains a collection of IDTSExternalMetadataColumn100 objects that represent the columns of an external data source.
Public interface IDTSFriendlyEnum100 Provides names for the values of an enumeration.
Public interface IDTSFriendlyEnumCollection100 Contains a collection of IDTSFriendlyEnum100 objects.
Public interface IDTSInput100 Contains the collection of columns that represents the data provided to a component in the form of PipelineBuffer objects at run time.
Public interface IDTSInputCollection100 Contains a collection of IDTSInput100 objects.
Public interface IDTSInputColumn100 Represents an output column of an upstream component that is selected for use by a component.
Public interface IDTSInputColumnCachedInfo100 Infrastructure. Represents the IDTS input column cached information.
Public interface IDTSInputColumnCollection100 Contains a collection of IDTSInputColumn100 columns.
Public interface IDTSLookupDesign100 Represents a DTS lookup interface.
Public interface IDTSManagedComponent100 Infrastructure. Represents an interface for the DTS managed components.
Public interface IDTSManagedComponentHost100 Infrastructure. Contains hosts for the IDTSManagedComponent100 objects.
Public interface IDTSManagedComponentWrapper100 Infrastructure. Represents the DTS managed component wrapper.
Public interface IDTSMultiInputComponent100 Infrastructure. Provides methods related to multiple input components.
Public interface IDTSMultiInputComponentHost100 Infrastructure. Provides methods related to multiple input component hosts.
Public interface IDTSObject100 Defines the base object interface for data flow objects.
Public interface IDTSObjectModel100 Infrastructure. Represents a model for the IDTSObject100.
Public interface IDTSOutput100 Contains the collection of IDTSOutputColumn100 columns available to downstream components in a graph.
Public interface IDTSOutputCollection100 Contains a collection of IDTSOutput100 objects.
Public interface IDTSOutputColumn100 Contains the design-time definition of a column provided by a component.
Public interface IDTSOutputColumnCollection100 Contains a collection of IDTSOutputColumn100 columns.
Public interface IDTSPath100 Represents a connection between two components.
Public interface IDTSPathCollection100 Provides a collection container for storing IDTSPath100 objects.
Public interface IDTSPersistenceComponent100 Infrastructure. Defines the persistence methods of a data flow component.
Public interface IDTSPipeline100 Defines the methods and properties implemented by the data flow task.
Public interface IDTSPivotDesign100 Represents a DTS pivot design interface.
Public interface IDTSRuntimeComponent100 Defines the run-time methods of a data flow component.
Public interface IDTSRuntimeConnection100 References a ConnectionManager object in a package.
Public interface IDTSRuntimeConnectionCollection100 Contains a collection of IDTSRuntimeConnectionCollection100 objects.
Public interface IDTSSupportBackPressure100 Infrastructure. Represents the data transformation services back pressure support.
Public interface IDTSVirtualInput100 Represents the columns available to a component from the upstream component.
Public interface IDTSVirtualInputColumn100 Represents an IDTSOutputColumn100 in the StartPoint object of an IDTSPath100 object.
Public interface IDTSVirtualInputColumnCollection100 Contains a collection of IDTSVirtualInputColumn100 columns.
Public interface MainPipe Provides the managed implementation of the IDTSPipeline100 interface used to programmatically configure a data flow task.

Enumerations

  Enumeration Description
Public enumeration DTPSTATUSENUM Specifies the status for a column in an IDTSBuffer100 object.
Public enumeration DTSBufferFlags Contains values that are used to register a buffer with the IDTSBufferManager100 object.
Public enumeration DTSBufferHandlePresetValues Specifies a defined set of buffer handles.
Public enumeration DTSCustomPropertyExpressionType Indicates whether the value of a custom property of a data flow component can be specified by using property expressions.
Public enumeration DTSInsertPlacement Specifies the location to insert a new IDTSInput100 or IDTSOutput100 object in the collection.
Public enumeration DTSObjectType Specifies the objects that implement the IDTSObject100 interface in the data flow object model.
Public enumeration DTSPersistenceFormat Specifies the persistence format of the objects in a data flow task.
Public enumeration DTSPersistState Specifies how an IDTSCustomProperty100 is persisted in the package XML file.
Public enumeration DTSPIPELINEVERSION Specifies the version of the data flow engine installed on the computer.
Public enumeration DTSRowDisposition Specifies how to proceed if an error or truncation occurs while processing a row.
Public enumeration DTSUsageType Indicates how an IDTSInputColumn100 object is used by a component.
Public enumeration DTSValidationStatus Specifies the return value of a call to Validate.