CHAPTER 11
Script Component Transformation
You can accomplish a lot with standard transformations, but sometimes the Script Component provides an easier solution. For example, a nested if construction is very possible in a derived column, but it becomes unreadable and unmaintainable if you have a lot of levels or conditions. And some features are just not available in the out-of-the-box components. This chapter shows some of the situations where a Script Component is useful.
Script Component Transformation
The basic structure of the Script Component transformation is to give you row-by-row access to the data coming from upstream. The transformation ...
Get Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
