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.

Note

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.

In This Section

• 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.

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: Visit the Integration Services page on MSDN Visit the Integration Services page on TechNet For automatic notification of these updates, subscribe to the RSS feeds available on the page.