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