Developing Specific Types of Data Flow Components

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.

In This Section

• 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.

Reference

• 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.

See Also

Reference

Comparing Scripting Solutions and Custom Objects

Concepts

Developing Specific Types of Script Components