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 17

image

Create Custom Transformation

This chapter shows you how to create a custom transformation for the data flow. Compared to the custom task, this is slightly more difficult because there are more methods and more points to address. To keep things comprehensible, you will be using the row number script that you saw in the Script Component chapters. A very basic transformation, but easy to extend with all the bells and whistles that you can find on the various blogs and forums.

Creating a custom transformation instead of a Script Component has the same pros and cons as the custom task vs. the Script Task (see Figure 17-1). However, because ...

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