Professional Microsoft SQL Server 2008 Integration Services

There are two keys to a successful ETL solution: using the right enterprise ETL tool and employing the right ETL architecture in order to meet the system requirements. With SQL Server 2008 Integration Services, half the battle is won. The out-of-the-box features provide the depth and breadth of functionality and flexibility needed to create scalable solutions. Even more, the usability and rapid learning curve reduce solution development time.The second ingredient is correct ETL architecture and design. When considerable effort is spent testing scenarios and proving out designs, valuable testing, implementation, and deployment time is lost. This book fills that gap.Professional SQL Server 2008 Integration Services will, of course, fully cover the new features of the 2008 product release, expected in mid-2008. These features may seem minor from the outside viewer but the learning curve on these features will be challenging.In this new edition, a major focus will be on expanding content to reflect best practices based on the nearly 3 years of experience the author team has had since the previous edition published. The authors will also expand technical coverage on certain topics that we were not able to address fully in the 2005 edition, providing more value to readers. For example, they will add a new chapter on data warehousing using SSIS and another on methods for managing the SSIS platform.The reader of the 2008 book will also have more experience on SSIS at this point and will be more discerning and advanced. To meet the demands of these experienced SSIS professionals, the authors will also add more case studies and tutorial examples to illustrate advanced concepts and techniques.Overall, the book will be about 25% revised, with 200 new pages.