Microsoft SQL Server 2008 Integration Services and over 2 million other books are available for Amazon Kindle . Learn more

Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Microsoft SQL Server 2008 Integration Services on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Microsoft SQL Server 2008 Integration Services Problem-design-solution [Unknown Binding]

4.0 out of 5 stars  See all reviews (2 customer reviews)

Currently unavailable.
We don't know when or if this item will be back in stock.

Product details

  • Unknown Binding
  • Language: English
  • ISBN-10: 0470593946
  • ISBN-13: 978-0470593943
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (2 customer reviews)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Inside This Book (Learn More)
Browse and search another edition of this book.
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Customer Reviews

4 star
2 star
1 star
4.0 out of 5 stars
4.0 out of 5 stars
Most Helpful Customer Reviews
3 of 3 people found the following review helpful
3.0 out of 5 stars Contains all the info, layout not clear enough 1 Jun 2010
Format:Paperback|Verified Purchase
After having been through the previous book, bought this to update to 2008 and found the previous book far easier to follow.

The book contains some excellent info, however I found during the hands-on parts, many of the steps that needed to be followed were buried in the main text and were therefore easy to miss.

Would (for my tiny brain) prefer numbered steps for these parts.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Excellent...but not for beginners 23 Feb 2011
I have found this book extremely useful as a practical guide. It is definitely not for beginners. It is mainly about SSIS as an ETL tool for loading a data warehouse. It presents different approaches (including the pros and cons of using them), guides on best practice
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 4.2 out of 5 stars  13 reviews
18 of 18 people found the following review helpful
5.0 out of 5 stars SQL Server Integration Services: Problem - Design - Solution 15 April 2010
By Tim D. Mitchell - Published on
I usually don't do book reviews (at least publicly, anyway), but when I find a piece of work that I really get a lot out of, I don't mind sharing my experience. Such was the case with a book I finished recently. SQL Server 2008 Integration Services: Problem - Design - Solution is a concise guide to becoming a better ETL developer, written by four highly experienced industry experts. After reading this book, I can recommend it without hesitation!

From the first few pages, it's obvious that this book is different from many other SSIS books. Rather than trying to teach the reader how to use the software, this book instead focuses on common business problems and the methodology behind solving them. The authors assume some familiarity with SSIS, so you won't find a comprehensive how-to manual if you've never created a package before. That being said, the concepts presented here are not so complex that only highly seasoned ETL developers will understand them; to the contrary, the book illustrates a number of simple yet practical approaches, along with relevant examples, that audiences of various skill levels will get something out of it.

One of the most relevant topics covered was the concept of building an SSIS management framework, which was my favorite part of the book. Having recently moved from an environment with a relatively small number of packages to a consulting role where I might interact with hundreds of packages a month, I found that a solid ETL framework is a critical component of success. Chapter 2 of the Problem - Design - Solution book explains why, and illustrates how, one would build an SSIS management framework. For anyone that has struggled with a large number of packages or has wrestled with the shortcomings of the built-in SSIS logging tools, this chapter should prove useful as both a guide and a best practices reference. Further into the book, the authors cover other topics essential to data warehousing ETL, including data cleansing and fact and dimension table ETL. The authors go on to cover scripting in SSIS, one of my favorite topics, and do a good job of addressing scripting patterns in both the script task and script component. Finally, the book reviews ways to monitor and improve SSIS performance.

I consider a technical book to be successful if it contains the right mix of information so that I can immediately apply what I've learned to legitimate problems and situation. To that end, this book is a winner in my opinion; even though I have been developing ETL processes in SSIS for years, I was able to walk away with some practical techniques that I began using almost immediately. Experienced ETL developers, as well as those with only a little SSIS experience, will likely find this book very useful.
8 of 8 people found the following review helpful
5.0 out of 5 stars A treasury of ETL best practices in action. 16 Feb 2010
By Shabnam Watson - Published on
This book is a treasury for ETL developers / architects. It is very different from other ETL books in the way that it is written with a top-to-bottom approach instead of focusing on details of an ETL tool. Each chapter presents a problem that an ETL developer/architect will face during a real project. Then it provides design ideas and best practices for the problem and finally delivers a solution that can be implemented. The collection of design ideas, best practices and solutions provided is priceless. The solutions are ready for use or require minimal change and presented in enough details for someone who is familiar with SSIS. This is the book you want to have if you want to know how the SSIS experts would solve the ETL problems you are facing.

The only chapter that falls short in comparison with others in terms of the quality of the solution provided is chapter 9 on SSAS processing. The information is useful and written with the same format of other chapters but is not as comprehensive and of the same caliber. Considering that the focus of this book is on SSIS and not SSAS, this chapter is a good starting point for SSAS processing.

One highlight of this book is that many of the design patterns and frameworks presented in this book are independent of the version of SQL Server and will be useful in future versions. There are many references to other useful books when the reader needs to gain a deeper background knowledge. This is a great book to keep and come back to.

Overall this book is written well, easy to understand, and chapters flow smoothly together. Once I started reading this book, it was hard to put it down.
7 of 7 people found the following review helpful
5.0 out of 5 stars Advanced SSIS, Thank You! 23 Mar 2010
By J. Cooke - Published on
Format:Paperback|Verified Purchase
This book is really good for more advanced users. If you have developed SSIS packages in the past, and want to take the next step to make your systems better, then get this book. I am a developer for a big company and I rarely see advanced "real world" examples of SSIS solutions. I love the first chapter on SSIS logging. Download the code from the website, and it will create your logging tables and procs with just minor modifications to the scripts.

I initially put off buying this book for a week because it only had one review at the time (even though it was 5 stars).
This is an excellent Book!
3 of 3 people found the following review helpful
4.0 out of 5 stars Good job, keep it up 24 April 2010
By Shahzad Khan - Published on
Format:Paperback|Verified Purchase
Not a beginner's book. Target audience is medium to expert level professionals.

Simply put, should I write code or architect a process flow (package) with minimum code effort to solve business problem? If architecting is a choice then this book is for you.

The book covers package framework, design and development. It walks you through design patterns for developing effective SSIS packages. There is a nice section on package's performance with comparison to memory and disk I/O bottlenecks.

The book also covers physical infrastructure and deployment by focusing on package deployment on single/multiple computers and talk about processor capacity, RAM and physical disk size.
3 of 3 people found the following review helpful
5.0 out of 5 stars Indispensable for Serious ETL Developers 23 April 2010
By Anthony Cheng - Published on
I echo the comments of the other reviewers. I bought this book, despite it only had one reviewer comment,largely because the authors. It turned out it was best decision I ever made. Unlike other SSIS books which teach you on how to use the software, this book instead focused on real world common issues faced by ETL developers. I specifically love the logging, and chapter 7 and 8 for dimension and fact. Regardles of your SSIS level, you will definitely learn something new from this. I highly recommend this book.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category