This topic has not yet been rated - Rate this topic

Developing Specific Types of Script Components

SQL Server 2012

SQL Server 2005

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.

In This Section

Creating a Source with the Script Component: Explains and demonstrates how to create a data flow source by using the Script component.
Creating a Synchronous Transformation with the Script Component: Explains and demonstrates how to create a data flow transformation with synchronous outputs by using the Script component. This kind of transformation modifies rows of data in place as they pass through the component.
Creating an Asynchronous Transformation with the Script Component: Explains and demonstrates how to create a data flow transformation with asynchronous outputs by using the Script component. This kind of transformation has to read all rows of data before it can add more information, such as calculated aggregates, to the data that passes through the component.
Creating a Destination with the Script Component: Explains and demonstrates how to create a data flow destination by using the Script component.

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 Data Flow Components

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD