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 14

image

Script Component Reflection

This chapter focuses on flexibility within the Script Component, because sometimes you have to do the same transformation for a lot of columns, which could be a little tiresome. Or what about Chapter 12’s XML destination with a lot of columns? You don’t want to code a couple dozen column names. On reflection, you can loop through all input columns on runtime. So you don’t have to hard-code all of those columns. Another great opportunity to use reflection is calculating a hash value for all the columns.

However, this flexibility comes with a price because reflection is not the best technique if performance ...

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