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

Get Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.