CHAPTER 8
Advanced Solutions with Script Task
This chapter is about common real-world scenarios that happen in ETL—scenarios such as compressing and decompressing files, or encrypting and decrypting files. Using .NET scripting would make these scenarios much easier to achieve. And what about using regular expressions to filter in a Foreach Loop?
Regular Expressions
Regular expressions are very useful for validating or cleaning data, which is hard or nearly impossible to do with SSIS expressions. You probably would expect them in the Data Flow Task (and in Chapter 13 you will see some very helpful examples of this), but they can be very useful ...
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.
