Hands-On Microsoft SQL Server 2008 Integration Services part 3. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. . | This page intentionally left blank Introduction Hands-On Microsoft SQL Server 2008 Integration Services is a revised edition of its predecessor which was based around SQL Server 2005 Integration Services. I have taken the opportunity to enhance the content wherever I felt could benefit readers more. The feedback I have received on the previous edition has been instrumental to these enhancements. Though not many new features have been packed in this release of Integration Services I think this book has gone steps beyond its previous release. Not only does it contain improved content and lots of relevant examples and exercises now it has two new chapters to cover topics such as programming and scripting SSIS and data warehouse practices. These chapters enable readers to extend their SSIS packages with programming and scripting and also show how SSIS can be put to use in large-scale data warehouse implementations thus extending the reach of the tool and the developer. This book has been targeted to reduce the learning curve of the readers and hence has a unique style of presenting the subject matter. Each topic includes a theoretical introduction but care has been taken not to present too much information at that stage. More details about the tasks and components are then included in the relevant Hands-on exercises that immediately follow the theoretical introduction. Lots of examples have been included to cover most commonly used business scenarios. All the files and code used in the examples have been provided for you to download from McGraw-Hill site. The appendix of this book contains more details on how to download and use the code. And finally the chapters have been organized in a way better suited to learning than a sectionalized approach. Chapters 1 and 2 cover the basic concepts an introduction to Integration Services new features in this release and the Import and Export Wizard. Chapters 3 4 and 5 walk through connection managers control flow tasks and .
