O'Reilly logo

Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services by Régis Baccaro, Joost van Rossum

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 11

image

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required