PROFESSIONAL MS SQL SERVER 2012 INTEGRATION

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 2012 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 2012 Integration Services will, of course, fully cover the new features of the 2011 product release, expected in early 2012.  This will be the most significant new release of the product since it was introduced in 2005--the book will be 70% revised and add 200 new pages, reflecting this major change in how the product looks and works. In addition to technical updates and additions, the authors will reflect a new set of best practices based on the 3 years of experience the author team has had since the previous edition published.   The reader of the 2012 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.

An in-depth look at the radical changes to the newest release of SISS Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this complex topic and provides detailed coverage of the new features of the 2012 product release. In addition to technical updates and additions, the authors present you with a new set of SISS best practices, based on years of real-world experience that have transpired since the previous edition was published. Details the newest features of the 2012 SISS product release, which is the most significant release since 2005 Addresses the keys to a successful ETL solution, such as using the right enterprise ETL tool and employing the right ETL architecture in order to meet the system requirements Includes additional case studies and tutorial examples to illustrate advanced concepts and techniques Professional Microsoft SQL Server 2012 Integration Services is a valuable resource that meets the demands and high expectations of experienced SSIS professionals.