Developing a Custom Data Flow Component
The data flow task consists of components that connect to a variety of data sources and then transform and route that data at high speed. Microsoft SQL Server 2005 Integration Services (SSIS) provides an extensible object model that lets developers create custom sources, transformations, and destinations that you can use in Business Intelligence Development Studio and in deployed packages. This section contains topics that will guide you in developing custom data flow components.
In This Section
| Topic | Description |
|---|---|
Describes the initial steps in creating a custom data flow component. |
|
Describes the design-time methods to implement in a custom data flow component. |
|
Describes the run-time methods to implement in a custom data flow component. |
|
Describes the data flow execution plan and the allocation of data buffers. |
|
Explains how the data flow maps Integration Services data types to .NET Framework managed data types. |
|
Explains the methods used to validate component configuration and to reconfigure component metadata. |
|
Explains how to use external metadata columns for data validation. |
|
Explains how to raise predefined and custom events. |
|
Explains how to create and write to custom log entries. |
|
Explains how to redirect error rows to an alternative output. |
|
Explains how to update saved component metadata when a new version of your component is first used. |
|
Explains how to implement a custom editor for a component. |
|
Contains information about developing the three types of data flow components: sources, transformations, and destinations. |
Reference
| Topic | Description |
|---|---|
Contains the classes and interfaces used to create custom data flow components. |
|
Contains the classes and interfaces that make up the data flow task object model, and is used to create custom data flow components or build a data flow task. |
|
Contains the classes and interfaces used to create the user interface for data flow components. |
|
Lists the predefined Integration Services error codes with their symbolic names and descriptions. |
Related Sections
For information that is common to all the type of custom objects that you can create in Integration Services, see the following topics.
| Topic | Description |
|---|---|
Describes the basic steps in implementing all types of custom objects for Integration Services. |
|
Describes custom persistence and explains when it is necessary. |
|
Describes the techniques for building, signing, deploying, and debugging custom objects. |
For information on the other types of custom objects that you can create in Integration Services, see the following topics.
| Topic | Description |
|---|---|
Discusses how to program custom tasks. |
|
Discusses how to program custom connection managers. |
|
Discusses how to program custom log providers. |
|
Discusses how to program custom enumerators. |
See Also
Reference
Comparing Scripting Solutions and Custom Objects
Concepts
Other Resources
Extending the Data Flow with the Script Component