Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services 1/E by Joost van Rossum, Regis Baccaro

You have some experience with creating SSIS packages, but encountered some of the limitations of the out-of-the-box tasks and transformations. You are not an experienced programmer, but maybe you have adjusted an Excel macro or added some simple JavaScript to your web site. At least you're not afraid to use some scripting if you get some good guidance.

Or you might have a .NET developer background and you want to understand how SSIS scripting integrates with the rest of the SSIS components for data transfer and consolidation purposes; or maybe you are a DBA interested in using SSIS to perform some administrative tasks. Regardless of your background and motivations for using SSIS scripting components, you need a proper fundamental and basic introduction to SSIS and scripting. Besides describing the fundamentals, this book also has a whole array of ready-made scripting examples for all common problems.