Developing Specific Types of Script Components
The Script component is a configurable tool that you can use in the data flow of a package to fill almost any requirement that is not met by the sources, transformations, and destinations that are included with Integration Services. This section contains Script component code samples that demonstrate the four options for configuring the Script component:
As a source.
As a transformation with synchronous outputs.
As a transformation with asynchronous outputs.
As a destination.
For additional examples of the Script component, see Additional Script Component Examples.