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

Topic Description

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

Topic Description

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

Help and Information

Getting SQL Server 2005 Assistance