Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace

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.

Classes

CManagedComponentWrapperClass

Represents the design-time instance of a data flow component.

DTSBufferManagerClass

Creates and manages IDTSBuffer100 objects.

MainPipeClass

Adds and connects components in a data flow layout.

Structs

BUFFER_WIRE_PACKET

Specifies the buffer wire packet of the pipeline wrapper.

DTP_BUFFCOL

Contains metadata that describes the data stored in a buffer column.

tagBUFFER_WIRE_PACKET

Specifies the buffer wire packet for the pipeline wrapper.

tagBUFFERCOL

Contains metadata that describes the data stored in a buffer column.

Interfaces

CManagedComponentWrapper

Configures the properties and column collections of a component.

DTSBufferManager

Manages IDTSBuffer100 objects.

IDTSBLOBObject100

Used to read and write bytes to a column in an IDTSBuffer100 object.

IDTSBuffer100

Represents an in-memory, two-dimensional storage object that contains rows and columns.

IDTSBufferManager100

Creates and manages IDTSBuffer100 objects.

IDTSBufferManagerInitialize100

Initializes the buffer manager for the pipeline wrapper.

IDTSBufferTapConfiguration100

Represents the tap configuration for the IDTSBuffer100 object.

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.

IDTSComponentMetaData130

Adds new functionality in SQL Server 2016 to the existing IDTSComponentMetaData100 interface, especially the GetIdentificationStringByID(Int32) method. The IDTSComponentMetaData100 interface 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.

IDTSComponentMetaDataCollection100

Contains a collection of IDTSComponentMetaData100 objects.

IDTSComponentView100

Allows changes to the IDTSComponentMetaData100 of a data flow component to be rolled back.

IDTSCustomProperty100

Contains custom information about an object in a data flow task.

IDTSCustomPropertyCollection100

Contains a collection of IDTSCustomProperty100 objects.

IDTSDataFileCreator100

Represents a DTS data file creator interface.

IDTSDesigntimeComponent100

Defines the design-time methods of a data flow component written in C++ and COM.

IDTSExpressionEvaluatorEx100

Evaluates targeting expressions.

IDTSExternalMetadataColumn100

Represents a column from an external data source.

IDTSExternalMetadataColumnCollection100

Contains a collection of IDTSExternalMetadataColumn100 objects that represent the columns of an external data source.

IDTSFriendlyEnum100

Provides names for the values of an enumeration.

IDTSFriendlyEnumCollection100

Contains a collection of IDTSFriendlyEnum100 objects.

IDTSInput100

Contains the collection of columns that represents the data provided to a component in the form of PipelineBuffer objects at run time.

IDTSInputCollection100

Contains a collection of IDTSInput100 objects.

IDTSInputColumn100

Represents an output column of an upstream component that is selected for use by a component.

IDTSInputColumn130

Adds new functionality in SQL Server 2016 to the existing IDTSInputColumn100 interface, especially the LineageIdentificationString property, which is used by the GetIdentificationStringByID(Int32) method.The IDTSInputColumn100 interface represents an output column of an upstream component that is selected for use by a component.

IDTSInputColumnCachedInfo100

Represents the IDTS input column cached information.

IDTSInputColumnCollection100

Contains a collection of IDTSInputColumn100 columns.

IDTSLookupDesign100

Represents a DTS lookup interface.

IDTSManagedComponent100

Represents an interface for the DTS managed components.

IDTSManagedComponentHost100

Contains hosts for the IDTSManagedComponent100 objects.

IDTSManagedComponentHost130
IDTSManagedComponentWrapper100

Represents the DTS managed component wrapper.

IDTSMultiInputComponent100

Provides methods related to multiple input components.

IDTSMultiInputComponentHost100

Provides methods related to multiple input component hosts.

IDTSObject100

Defines the base object interface for data flow objects.

IDTSObjectModel100

Represents a model for the IDTSObject100.

IDTSOutput100

Contains the collection of IDTSOutputColumn100 columns available to downstream components in a graph.

IDTSOutputCollection100

Contains a collection of IDTSOutput100 objects.

IDTSOutputColumn100

Contains the design-time definition of a column provided by a component.

IDTSOutputColumn130

Adds new functionality in SQL Server 2016 to the existing IDTSOutputColumn100 interface, especially the LineageIdentificationString property, which is used by the GetIdentificationStringByID(Int32) method.The IDTSOutputColumn100 interface contains the design-time definition of a column provided by a component..

IDTSOutputColumnCollection100

Contains a collection of IDTSOutputColumn100 columns.

IDTSPath100

Represents a connection between two components.

IDTSPathCollection100

Provides a collection container for storing IDTSPath100 objects.

IDTSPersistenceComponent100

Defines the persistence methods of a data flow component.

IDTSPipeline100

Defines the methods and properties implemented by the data flow task.

IDTSPipeline130
IDTSPivotDesign100

Represents a DTS pivot design interface.

IDTSRuntimeComponent100

Defines the run-time methods of a data flow component.

IDTSRuntimeComponent130
IDTSRuntimeConnection100

References a ConnectionManager object in a package.

IDTSRuntimeConnectionCollection100

Contains a collection of IDTSRuntimeConnectionCollection100 objects.

IDTSSupportBackPressure100

Represents the data transformation services back pressure support.

IDTSVirtualInput100

Represents the columns available to a component from the upstream component.

IDTSVirtualInputColumn100

Represents an IDTSOutputColumn100 in the StartPoint object of an IDTSPath100 object.

IDTSVirtualInputColumnCollection100

Contains a collection of IDTSVirtualInputColumn100 columns.

MainPipe

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

Enums

DTPSTATUSENUM

Specifies the status for a column in an IDTSBuffer100 object.

DTSBufferFlags

Contains values that are used to register a buffer with the IDTSBufferManager100 object.

DTSBufferHandlePresetValues

Specifies a defined set of buffer handles.

DTSCustomPropertyExpressionType

Indicates whether the value of a custom property of a data flow component can be specified by using property expressions.

DTSInsertPlacement

Specifies the location to insert a new IDTSInput100 or IDTSOutput100 object in the collection.

DTSObjectType

Specifies the objects that implement the IDTSObject100 interface in the data flow object model.

DTSPersistenceFormat

Specifies the persistence format of the objects in a data flow task.

DTSPersistState

Specifies how an IDTSCustomProperty100 is persisted in the package XML file.

DTSPIPELINEVERSION

Specifies the version of the data flow engine installed on the computer.

DTSRowDisposition

Specifies how to proceed if an error or truncation occurs while processing a row.

DTSUsageType

Indicates how an IDTSInputColumn100 object is used by a component.

DTSValidationStatus

Specifies the return value of a call to Validate().

Remarks

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