Expert SQL Server 2005 Integration Services (Programmer to Programmer) [Paperback]

Brian Knight (Author), Erik Veerman (Author)

Book Description

ISBN-10: 0470134119 | ISBN-13: 978-0470134115 | Publication Date: May 29, 2007 | Edition: 1

As a practical guide for Integration Services ETL development, this book shows you 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 with the end goal of putting it all together to get a solution.

Editorial Reviews

From the Back Cover

Developing data processing extraction, transformation, and loading (ETL) solutions is now easier than ever with this practical guide. It shows you how to apply the components of SQL Server 2005 Integration Services (SSIS) to build an enterprise ETL application that scales and performs to your specifications. You'll not only learn how to design and implement the necessary architecture, you'll also find out how to utilize the proper administration techniques.

Written by two SQL Server MVPs, this book first provides you with all the background and foundation information you'll need on scripting and data extraction. It then takes you through the details of data warehousing ETL, error handling, administration, and data integration. By following this approach, you'll quickly discover how to take advantage of SSIS functionality to meet your data integration and processing requirements.

What you will learn from this book

• Powerful uses of scripting to develop more advanced applications

• All about the relational database transformation and loading methods for dimension and fact tables

• Steps for creating sophisticated solutions that easily handle processing errors

• Best practices for moving between your support and production environments

• Tips for leveraging SSIS features that make your migrated packages better

• How to design and tune your packages to achieve the most scalability

Who this book is for

This book is for experienced SQL Server database developers, architects, and administrators who want to build ETL applications using SSIS.

Wrox Expert books present the wisdom accumulated by an experienced author team who is recognized as experts by the programming community. These experts challenge professional developers to examine their current practices in pursuit of better results.

Enhance Your Knowledge

Advance Your Career

About the Author

Brian Knight (SQL Server MVP, MCSE, MCDBA) of Green Cove Springs, Florida, is the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG) and was on the Board of Directors of the Professional Association for SQL Server (PASS). He is a contributing columnist for SQL Server Standard and also maintains a regular column for the database web site, SQLServerCentral.com, as well as doing regular webcasts at JumpstartTV.com. He has co-authored and authored more than nine SQL Server books, including Admin911: SQL Server 2000 (McGraw-Hill Companies, 2001), Professional SQL Server 2000 DTS (Wiley Publishing, 2000), Professional SQL Server 2005 Administration (Wiley Publishing, 2006), and Professional SQL Server 2005 Integration Services (Wiley Publishing, 2006). He has spoken at conferences such as PASS, SQL Connections, and TechEd, as well as at many Code Camps. His blog can be found at www.whiteknighttechnology.com. He is an independent consultant at Pragmatic Works and spends most of his time trying to think about how to use the word onomatopoeia in everyday sentences.

Erik Veerman (SQL Server MVP, MCT, MCDBA) is a Mentor for Solid Quality Learning focusing on training, mentoring, and architecting solutions on the SQL Server Business Intelligence (BI) platform. His industry recognition includes Microsoft’s Worldwide BI Solution of the Year and SQL Server Magazine’s Innovator Cup winner. He has designed dozens of BI solutions across a broad business spectrum—telecommunications, marketing, retail, commercial real estate, finance, supply chain, and information technology. His experience with high-volume, multi-terabyte environments and SQL Server 64-bit has enabled clients to scale their Microsoft-based BI solutions for optimal potential. As an expert in OLAP design, ETL processing, and dimensional modeling, he is a presenter, author, and instructor. He led the ETL architecture and design for the first production implementation of SQL Server Integration Services (SSIS) and helped drive the ETL standards and best practices for SSIS on Microsoft’s SQL Server 2005 reference initiative (Project REAL). He also co-authored Professional SQL Server 2005 Integration Services (Wiley Publishing, 2006). As a resident of Atlanta, Georgia, Erik is a leader of the local Atlanta SQL Server User’s Group, a PASS and INETA user group chapter.

Product Details

• Paperback: 432 pages
• Publisher: Wrox; 1 edition (May 29, 2007)
• Language: English
• ISBN-10: 0470134119
• ISBN-13: 978-0470134115
• Product Dimensions: 9.2 x 7.4 x 0.9 inches
• Shipping Weight: 1.3 pounds (View shipping rates and policies)
• Average Customer Review: 4.4 out of 5 stars  See all reviews (16 customer reviews)
• Amazon Best Sellers Rank: #767,182 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

21 of 21 people found the following review helpful:

5.0 out of 5 stars Required reference book for your SSIS library, August 8, 2007

By 

Stacia Misner "BI consultant, educator, author" (Las Vegas, NV) - See all my reviews
(REAL NAME)   

This review is from: Expert SQL Server 2005 Integration Services (Programmer to Programmer) (Paperback)

If you're new to Integration Services, this book is not for you. You should instead start with Professional SQL Server 2005 Integration Services (Programmer to Programmer). However, if you've already developed some skills with Integration Services (SSIS), but are still wondering how to best use this tool to perform ETL tasks, then you will definitely want this book at your side. The authors cover all of the subject areas they teach in the classroom (and more), which makes this a great reference book whether or not you're able to attend their training classes. Not only do Erik and Brian present alternative methods for accomplishing similar data integration objectives, they clearly explain the pros and cons of each approach. Another important subject they cover in the book is a thorough review of potential performance issues and suggestions for improving performance. Many books on SSIS do a good job of explaining the features and functions of SSIS, which this book does not attempt to replicate. Instead, the authors provide references to other sources for the basics, focus on information you won't find elsewhere, and give practical examples for deploying, maintaining, and tuning packages. For your ETL projects, this book is an indispensable guide.

13 of 13 people found the following review helpful:

5.0 out of 5 stars A Great 'Ramp up' reference, August 27, 2007

By 

Chris Fussell - See all my reviews

This review is from: Expert SQL Server 2005 Integration Services (Programmer to Programmer) (Paperback)

As a professional consultant, I see a lot of books on technology that do a good job of explaining the parts of the technology but don't provide much value in the actual application of the technology. This is not one of those books...

I recently used this book as part of my own ramping up on SSIS, having a great deal of experience with SQL2000+DTS but no real hands-on experience with SSIS. I found the format of the book to be easy to follow and navigate; the samples and recommendations were particularly useful and I used them throughout a recent project, where we were delivering an reasonably complex ETL solution based on SSIS.

I would certainly recommend this book to my fellow consultants and to anyone looking for a useful and practical guide to using SSIS.

8 of 8 people found the following review helpful:

5.0 out of 5 stars A True Experts Guide, May 25, 2007

By 

WollMatt "BI Consultant" (Atlanta, Ga USA) - See all my reviews

This review is from: Expert SQL Server 2005 Integration Services (Programmer to Programmer) (Paperback)

This book is true to its title of Expert. It goes beyond what you can find in Books Online and other SSIS books. The flow of the book is goes into more real world examples, which make the book a much easier read, then most technical books. You will find plenty of examples and images throughout each chapter.

I have been working with SSIS since its early CTP days and I find this book very useful.