"Microsoft[registered] SQL Server 2005 Integration Services" is by Kirk Haselden. Foreword is by Bill Baker, Microsoft[registered] Corporation. This book starts with a gentle introduction to the basic concepts underlying Integration Services, and each chapter gradually builds on earlier chapters with technical and easy-to-understand explanations of key features and components. Later chapters explain the details of how to work in the Integration Services environment, including how to set up stock components, use the various designer features, and practical advice on configuring, deploying, securing, and managing packages. Numerous sample packages are provided to reinforce the discussion, quickly build hands-on experience, and serve as boilerplate packages for starting new solutions. The last section of the book covers more advanced topics, such as Data Flow Task internals and tuning, advanced transformations, and writing custom components with easy-to-understand graphics to illustrate key points. Additionally, there are several custom tasks, custom transformations, and two useful utilities with full source code available for you to use and study, including an ADO.N ET destination, a text file encryption task, and a data profiling transform. It helps you understand how to: build robust packages to solve common requirements; secure packages for different environments; use often overlooked or unknown features; set up all the stock components, including data flow components, tasks. For each enumerators, connection managers, and log providers, it helps to write robust and useful custom tasks; build packages that seamlessly deploy to other environments; write custom data flow adapters and transforms; use script tasks and components; easily modify configurations for multiple packages simultaneously; write a Task UI that looks just like the stock tasks; tap into the power of Integration Services for accessing heterogeneous data sources; use expressions to make packages more responsive to the environment; and, migrate your DTS packages with no stress. Kirk Haselden is the Development Manager on the Integration Services team and has been with Microsoft for 10 years in various groups, including Hardware, eHome, and five years in the SQL Server group developing Integration Services. Before Microsoft, Kirk worked for various small-to-midsized software companies writing educational, dental, and online software. Kirk is married and the father of five wonderful children. He enjoys family time, photography, snow skiing, wake boarding, racquetball, motorcycle riding, hiking, breathing, drinking, and eating. He's always wearing hideous Hawaiian shirts, shorts, and sandals, except in the winter, when he also wears socks. He once lived in Wichita, Kansas and thinks it's funny when people talk about themselves in third person.