Extending the Data Flow with the Script Component
The Script component extends the data flow capabilities of Microsoft SQL Server 2005 Integration Services (SSIS) packages with custom code written in Microsoft Visual Basic .NET that is compiled and executed at package run time. The Script component simplifies the development of a custom data flow source, transformation, or destination when the sources, transformations, and destinations included with SQL Server 2005 Integration Services do not fully satisfy your requirements. After you configure the component with the expected inputs and outputs, it writes all the required infrastructure code for you, letting you focus exclusively on the code that is required for your custom processing.
A Script component interacts with the containing package and with the data flow through the autogenerated classes in the ComponentWrapper and BufferWrapper project items, which are instances of the ScriptComponent and the ScriptBuffer classes respectively. These classes make connections, variables, and other package items available as typed objects, and manage inputs and outputs. The Script component can also use the Visual Basic .NET namespace and the .NET Framework class library, as well as custom assemblies, to implement custom functionality.
The Script component and the infrastructure code that it generates for you simplify significantly the process of developing a custom data flow component. However, to understand how the Script component works, you may find it useful to read the section Developing a Custom Data Flow Component to understand the steps that are involved in developing a custom data flow component.
If you are creating a source, transformation, or destination that you plan to reuse in multiple packages, you should consider developing a custom component instead of using the Script component. For more information, see Developing a Custom Data Flow Component.
In This Section
The following topics provide more information about the Script component.
| Topic | Description |
|---|---|
Configuring the Script Component in the Script Component Editor |
Properties that you configure in the Script Transformation Editor affect the capabilities and the performance of Script component code. |
The Visual Studio for Applications (VSA) development environment is used to develop the scripts contained in the Script task. |
|
A new Script component project contains three project items with several classes and autogenerated properties and methods. |
|
The ComponentWrapper project item contains strongly-typed accessor properties for package variables. |
|
The ComponentWrapper project item also contains strongly-typed accessor properties for connections defined in the package. |
|
You can raise events to provide notification of problems and errors. |
|
You can log information to log providers enabled on the package. |
|
These simple examples explain and demonstrate how to use the Script component to develop data flow sources, transformations, and destinations. |
|
These simple examples explain and demonstrate a few possible uses for the Script component. |
See Also
Reference
Comparing the Script Task and the Script Component