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