Script Component Foundation
If you have an abnormal flat file format, or you want to use regular expressions to clean your data, or you need an XML destination, then the Script Component is one of your best choices. The Script Component is part of the data flow in SSIS; it provides a scripting editor for you. It can be used as a source, a transformation, or a destination. In this chapter, you deep-dive into the Script Component and some of the most common usages of this component. You will learn how to use variables, connection managers, logging methods, and error handling in a Script Component.
Because the Script Component can ...