Export (0) Print
Expand All

Additional Script Component Examples

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 various types of functionality that are available.

For samples that demonstrate how to configure the Script component as a basic source, transformation, or destination, see Developing Specific Types of Script Components.

NoteNote

If you want to create components that you can more easily reuse across multiple Data Flow tasks and multiple packages, consider using the code in these Script component samples as the starting point for custom data flow components. For more information, see Developing a Custom Data Flow Component.

Simulating an Error Output for the Script Component

The Script component does not support a standard error output, but you can simulate a standard error output with very little additional configuration and coding.

Enhancing an Error Output with the Script Component

Explains and demonstrates how to add additional information to a standard error output by using the Script component.

Creating an ODBC Destination with the Script Component

Explains and demonstrates how to create an ODBC data flow destination by using the Script component.

Parsing Non-Standard Text File Formats with the Script Component

Explains and demonstrates how to parse two different non-standard text file formats into destination tables.

Integration Services icon (small) 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 or TechNet:

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft