Currently unavailable.
We don't know when or if this item will be back in stock.
Have one to sell?
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

4.0 out of 5 stars 2 customer reviews

See all 3 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
--This text refers to the Paperback edition.
Currently unavailable. We don't know when or if this item will be back in stock.
Customers also viewed these available items
click to open popover

What other items do customers buy after viewing this item?

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.

Product details

  • Unknown Binding
  • ISBN-10: 0470593946
  • ISBN-13: 978-0470593943
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (2 customer reviews)
  • If you are a seller for this product, would you like to suggest updates through seller support?

Product description

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 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.

--This text refers to the Paperback edition.

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 and

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

--This text refers to the Paperback edition.

Customer Reviews

4.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See both customer reviews
Share your thoughts with other customers

Top Customer Reviews

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 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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 One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Helpful Customer Reviews on (beta) (May include reviews from Early Reviewer Rewards Program) 3.9 out of 5 stars 15 reviews
1 of 1 people found the following review helpful
4.0 out of 5 stars Great book to use when trying to get a handle on SSIS implementaions 12 April 2013
By Michael K. Broadbent - Published on
Format: Paperback Verified Purchase
I've worked with SQL Server (97 2000 2005 2008) for 13 years. Was laid off six months ago so I have some time on my hands while I look for work, so I thought I should work on expanding my SQL skills. I have T-SQL down, no problems there.

I can do anything needed in SSIS (control flow and data flow), but this book made me realize a major shortcoming in my general approach and the approach of the company I worked at. We treated each SSIS implementation as a separate, unique project. Each SSIS package had it's own configuration setup, non-shared logging and auditing schemes and none of it was scalable. This resulted in a mish-mash of styles in our hundreds of SSIS packages throughout the company.

If you have any experience with SQL Server and SSIS, this book can be used as a great roadmap for creating an overall architecture for SSIS implementations. The best time to impose this roadmap is prior to creating any SSIS packages, there are advisories to this effect in the book. Due to my prior experience above, I can tell you they are exactly right in saying that. If you already have a few SSIS packages built, (what's a few? <20?), it wouldn't be a huge effort to go back and retrofit the existing packages into the recommended architecture.

I've been angling for a consulting job that requires SQL Server and more importantly, SSIS experience. The customer is changing over from an ETL layer that is T-SQL code-heavy to one that is going to be SSIS-heavy. When I interview, the concepts in this book are going to get me that job.
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.
4.0 out of 5 stars Very well structured and highly useful 28 July 2014
By Sunny - Published on
Format: Paperback Verified Purchase
So far, I have read only the first 2-3 chapters but I must say that I really found the book very informative. The approaches mentioned are so helpful especially for those who do NOT yet have enough experience with SSIS or IT industry in general.

Very well structured and written.
5.0 out of 5 stars either as an IT pro or a business analyst would find this book useful. I still have it around and have recommended ... 25 July 2015
By DenV - Published on
Format: Paperback Verified Purchase
Anybody who has done any ETL processing work, either as an IT pro or a business analyst would find this book useful.
I still have it around and have recommended it to several friends.
Were these reviews helpful? Let us know

Look for similar items by category