Microsoft SQL Server 2008 Integration Services and over one million other books are available for Amazon Kindle. Learn more
  • List Price: $49.99
  • Save: $32.49 (65%)
Rented from apex_media
To Rent, select Shipping State from options above
Due Date: Dec 22, 2014
FREE return shipping at the end of the semester. Access codes and supplements are not guaranteed with rentals.
FREE Shipping on orders over $35.
Used: Good | Details
Sold by apex_media
Condition: Used: Good
Comment: Ships direct from Amazon! Qualifies for Prime Shipping and FREE standard shipping for orders over $25. Overnight and 2 day shipping available!
Access codes and supplements are not guaranteed with used items.
Add to Cart
Qty:1
  • List Price: $49.99
  • Save: $14.72 (29%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $7.57
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution Paperback – October 16, 2009

ISBN-13: 978-0470525760 ISBN-10: 0470525762 Edition: 1st

Buy New
Price: $35.27
Rent
Price: $17.50
36 New from $24.98 27 Used from $20.39
Rent from Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$17.50
$35.27
$24.98 $20.39

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student




Frequently Bought Together

Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution + Professional Microsoft SQL Server 2008 Integration Services + Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services
Price for all three: $102.63

Buy the selected items together

NO_CONTENT_IN_FEATURE

Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

  • Paperback: 480 pages
  • Publisher: Wrox; 1 edition (October 16, 2009)
  • Language: English
  • ISBN-10: 0470525762
  • ISBN-13: 978-0470525760
  • Product Dimensions: 9.2 x 7.4 x 1 inches
  • Shipping Weight: 1.8 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (14 customer reviews)
  • Amazon Best Sellers Rank: #726,481 in Books (See Top 100 in Books)

Editorial Reviews

From the Back Cover

Build practical SSIS solutions to real-world problems

SQL Server Integration Services (SSIS) is the most widely adopted Business Intelligence (BI) component of SQL Server and the leading extraction, transformation, and loading (ETL) tool in the data warehouse industry. Written by a team of Microsoft MVPs for SQL Server, this book presents you with an array of common problems that SSIS administrators and developers face on a daily basis, and walks you through the steps necessary to solve these challenges.

  • Demonstrates how to solve common pitfalls involved with SSIS deployment

  • Shares solutions for challenges you may encounter with package deployment and storage decisions

  • Explores file handling and processing methods

  • Reviews best practices for data extraction

  • Covers the basic concepts and challenges of dimension table ETL and fact table ETL

  • Solves problems that may arise with scripting design patterns and SSIS package scaling

  • Discusses how to effectively scale and performance-tune SSIS packages

wrox.com

Wrox Problem – Design – Solution references give you solid, workable solutions to real-world development problems. Each chapter is devoted to a different scenario, analyzing every problem, examining relevant design issues, and implementing the ideal solution.

Programmer Forums
Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.

Code Downloads
Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.

Read More
Find articles, ebooks, sample chapters and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.

About the Author

Erik Veerman is a Microsoft MVP for SQL Server and a mentor for Solid Quality Mentors. He is a coauthor of Professional SQL Server 2008/2005 Integration Services with Brian Knight.

Jessica M. Moss is a Microsoft MVP in SQL Server and a BI mentor, consultant, and trainer with Solid Quality Mentors.

Brian Knight is a Microsoft MVP For SQL Server and the cofounder of SQLServerCentral.com and JumpstartTV.com.

Jay Hackney is a mentor and consultant for Solid Quality Mentors, who works with SSIS to provide data warehousing and ETL solutions.


More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.2 out of 5 stars
5 star
8
4 star
4
3 star
0
2 star
1
1 star
1
See all 14 customer reviews
I specifically love the logging, and chapter 7 and 8 for dimension and fact.
Anthony Cheng
Experienced ETL developers, as well as those with only a little SSIS experience, will likely find this book very useful.
Tim D. Mitchell
The collection of design ideas, best practices and solutions provided is priceless.
Shabnam Watson

Most Helpful Customer Reviews

18 of 18 people found the following review helpful By Tim D. Mitchell on April 15, 2010
Format: Paperback
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.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 8 people found the following review helpful By Shabnam Watson on February 16, 2010
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 7 people found the following review helpful By J. Cooke on March 23, 2010
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!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Shahzad Khan on April 24, 2010
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Anthony Cheng on April 22, 2010
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Most Recent Customer Reviews

Search