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