This topic has not yet been rated - Rate this topic

Developing Specific Types of Data Flow Components

SQL Server 2012

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.

Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:

Visit the Integration Services page on MSDN

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Reference

Comparing Scripting Solutions and Custom Objects

Concepts

Developing Specific Types of Script Components

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD