Professional Microsoft SQL Server 2008 Integration Services (Wrox Programmer to Programmer)
Take your SSIS skills to a new level with a team of professionals to show you how to be effective, save time, and make your life easier. Learn from case studies and tutorials acquired over the three years since the previous edition. New content includes coverage of data warehouseing using SSIS, new methods for managing the SSIS platform, improved techniques for ETL operations, and much more.
Wiley brings us a sample chapter from this book. Read Chapter 9 on SSIS scripting to see if this is a resource that will help you.
Chapter 9 - Scripting in SSIS