Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution

Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution

<p>An authoritative guide to designing effective solutions for data cleansing, ETL, and file management with SQL Server 2008 Integration Services</p> <p>SQL Server Integration Services (SSIS) is the leading tool in the data warehouse industry, used for performing extraction, transformation, and load operations.</p> <p>After an overview of SSIS architecture, the authors walk you a series of real-world problems and show various techniques for handling them.</p> <ul> <li>Shows you how to design SSIS solutions for data cleansing, ETL and file management</li> <li>Demonstrates how to integrate data from a variety of data sources,</li> <li>Shows how to monitor SSIS performance,</li> <li>Demonstrates how to avoid common pitfalls involved with SSIS deployment</li> <li>Explains how to ensure performance of the deployed solution and effectively handle unexpected system failures and outages</li> <li>The companion Web site provides sample code and database scripts that readers can directly implement</li> </ul> <p>This book shows you how to design, build, deploy, and manage solutions to real-world problems that SSIS administrators and developers face day-to-day.</p>