Additional Script Component Examples
Applies To: SQL Server 2016 Preview
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.
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.