CHAPTER 8

image

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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.