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

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