Expert SQL Servertm 2005 Integration Services

by Brian Knight, Erik Veerman

When it comes to developing an enterprise ETL system, moving from theory to practice often presents the biggest hurdle. Not only can the primary data processing tasks be complex in themselves, but add in administration, error handling, scalability, testing and deployment and the result is like juggling spinning plates. It's no wonder why ETL consumes over 60 percent of an enterprise data warehouse development effort.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 2005 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. As a practical guide for Integration Services ETL development, you will learn ways to implement your ETL solution requirements from the data to the administration and everything in-between. Each chapter begins with a review of pertinent ETL concepts and moves into working those out into a design with multiple examples and related Integration Services features. Putting it all together to get a solution over the goal line requires knowing the big picture and coordinating all the pieces. The book, in short: ETL soup to nuts with Integration Services.

Genres: Bisexual

430 pages, Kindle Edition

First published January 1, 2007

About the author

Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of SQLServerCentral.com, JumpstartTV.com, and is on the Principal Board of Directors of the Professional Association for SQL Server (PASS). Brian is a contributing columnist for many industry magazines and sites. He has co-authored and authored more than 9 SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps.
--from the author's website

Librarian Note: There is more than one author in the GoodReads database with this name.