Developing Specific Types of Data Flow Components

 

Applies To: SQL Server 2016 Preview

This section covers the specifics of developing source components, transformation components with synchronous outputs, transformation components with asynchronous outputs, and destination components.

For information about component development in general, see Developing a Custom Data Flow Component.

Developing a Custom Source Component
Contains information on developing a component that accesses data from an external data source and supplies it to downstream components in the data flow.

Developing a Custom Transformation Component with Synchronous Outputs
Contains information on developing a transformation component whose outputs are synchronous to its inputs. These components do not add data to the data flow, but process data as it passes through.

Developing a Custom Transformation Component with Asynchronous Outputs
Contains information on developing a transformation component whose outputs are not synchronous to its inputs. These components receive data from upstream components, but also add data to the dataflow.

Developing a Custom Destination Component
Contains information on developing a component that receives rows from upstream components in the data flow and writes them to an external data source.

Microsoft.SqlServer.Dts.Pipeline
Contains the classes and interfaces used to create custom data flow components.

Microsoft.SqlServer.Dts.Pipeline.Wrapper
Contains the unmanaged classes and interfaces of the data flow task. The developer uses these, and the managed Microsoft.SqlServer.Dts.Pipeline namespace, when building a data flow programmatically or creating custom data flow components.

Comparing Scripting Solutions and Custom Objects
Developing Specific Types of Script Components

Community Additions

ADD
Show: