Professional Microsoft SQL Server 2012 Integration Services and over one million other books are available for Amazon Kindle. Learn more
CDN$ 30.00
  • List Price: CDN$ 59.99
  • You Save: CDN$ 29.99 (50%)
Only 2 left in stock (more on the way).
Ships from and sold by
Gift-wrap available.
Professional Microsoft SQ... has been added to your Cart
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 all 2 images

Professional Microsoft SQL Server 2012 Integration Services Paperback – Mar 27 2012

See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
"Please retry"
CDN$ 30.00
CDN$ 26.39 CDN$ 29.14

Frequently Bought Together

Professional Microsoft SQL Server 2012 Integration Services + Professional Microsoft SQL Server 2012 Reporting Services + Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX
Price For All Three: CDN$ 100.61

Buy the selected items together

Product Details

  • Paperback: 960 pages
  • Publisher: Wrox (March 27 2012)
  • Language: English
  • ISBN-10: 111810112X
  • ISBN-13: 978-1118101124
  • Product Dimensions: 18.8 x 4.1 x 23.4 cm
  • Shipping Weight: 1.5 Kg
  • Average Customer Review: 3.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #260,814 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

From the Back Cover

Practical solutions and best practices for getting the most out of Microsoft SQL Server Integration Services

The 2012 release of Microsoft SQL Server Integration Services (SSIS) offers significant new and enhanced features that greatly expand the capabilities of this product—but only if you know how to exploit them effectively. This book shows you how. It not only covers the latest features of the 2012 product release, it teaches you best practices for using them effectively. Each chapter includes helpful case studies and tutorial examples—all based on years of the expert authors' real-world experience—to better illustrate concepts and techniques.

Professional Microsoft SQL Server 2012 Integration Services:

  • Explains how to extract, transform, and load (ETL) data with SSIS

  • Covers each of the many SSIS tasks and Data Flow components

  • Teaches you the most effective techniques for performance tuning SSIS

  • Covers advanced techniques for data cleansing and incremental loads

  • Shows how to load a data warehouse using built-in components in SSIS

  • Covers best practices for manageability and scalability

Wrox Professional guides are written by working developers to address everyday needs. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job. 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

Brian Knight is the founder of Pragmatic Works and co-founder of and

Erik Veerman is a consultant, author, trainer, and a mentor with SolidQ. His award-winning industry recognition includes Microsoft's BI Solution of the Year and SQL Server Magazine's Innovator Cup.

Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server business intelligence who has created data warehousing solutions for a variety of industries.

Mike Davis, MCTS, MCITP, is the Managing Project Lead at Pragmatic Works. He has co-authored several business intelligence books and regularly speaks at SQL events.

Chris Rock is a software developer and program manager at Pragmatic Works, where he develops custom SSIS components and software.

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

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

3.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See the customer review
Share your thoughts with other customers

Most helpful customer reviews

Format: Paperback Verified Purchase
I generally find WROX press books a little 'better' than this one, but it's 'ok' if you're needing just a book to fill your shelf. But, I really find it lacking in a few things that would be really helpful;

- The samples don't always work as intended (and often because the instructions just aren't that clear, or include something in the paragraph above the example). The SSIS Script Task is a perfect example, where the instructions could have been so much clearer.
- Organization is generally sub-par, it'd be really helpful if this book was organized better.
- More tutorials would be helpful, maybe they're there, and I just can't find them due to the organization?

It's a good overall book, but I'll be looking for a better substitute, and this will be relegated to the back shelves of the bookshelf.
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.

Most Helpful Customer Reviews on (beta) 18 reviews
22 of 24 people found the following review helpful
Tiny Screenshots and Lots of Typos March 2 2013
By JShew - Published on
Format: Paperback Verified Purchase
I am a SQL Server database administrator, and I have worked with SQL Server for more than 15 years. Many years ago, I worked with DTS (Data Transformation Services) in SQL 2000, and I have worked briefly with SSIS (SQL Server Integration Services) 2008 R2. I purchased this book because I recognized some of the authors' names, and I had hoped the book would quickly bring me up-to-speed with SSIS 2012. However, I am disappointed with the book.

Unfortunately, the chapter layout did not work well for me. The first seven chapters (i.e., the first 231 pages) contain lots of "stub" code, but I don't recall any end-to-end examples. Chapter 8 (aptly named, "Creating an End-to-End Package") is the first complete tutorial for creating a useful package. However, the entire book is littered with typos. (No, I am not exaggerating here.) A tutorial object will be called one thing when you are asked to create it or rename it, and a later screenshot will display the same object with a different name, or a later reference on the next page will use a different name. And, subtle steps in the examples are skipped. Some of the book's content is out of order. For example, SSIS catalog logging is discussed on page 582, which is 166 pages before the creation of an SSIS catalog. You cannot work through this book from beginning to end. You have to use the index to hop around.

Virtually all of the screenshots are tiny. Often, a screenshot is roughly only 2 inches by 2 inches in size, and two screenshots are often placed side by side on the same page. I used a magnifying glass many times to decipher the screenshots, although I have "20 20" corrected vision. Fortunately, the print quality is good enough for a magnifying glass to work.

I suppose this is a useful book (if you don't mind scratching your head a lot to figure out how to make the examples work), but it was much harder to use than I anticipated (mostly because of the tiny screenshots and typos). The most useful chapters for me were 6, 8, 12, 16, and 17. Chapter 22 (Administering SSIS), one of the reasons I bought the book, is an absolute mess.
8 of 8 people found the following review helpful
Too Many errors May 31 2013
By Antonio Fallucca - Published on
Format: Paperback Verified Purchase
After reading this book I was disappointed. Too many errors in the book. At first I thought I would keep track of them then post them on the site to help others. But it got so bad that I just stopped. I think they just pushed this out to be one of the first. The problem with that is next time many people will not buy their book. I was greatly disappointed with this release. Too many important things left out, and too much talking detail.
3 of 3 people found the following review helpful
Full of errors, poorly written July 11 2014
By ad_crumenam - Published on
Format: Paperback
The book contains too many errors, typos, bad screenshots, and verbiage that does not match the actual product. It also skips around during exercises and it's difficult to actually follow along, which is how most of us learn. I'm getting a headache from it and I'm only on chapter 6. I don't think I've learned anything at all. I seriously hate this book.
3 of 4 people found the following review helpful
A must have book for SSIS developers Aug. 20 2012
By ajitk - Published on
Format: Paperback
This book explains each SSIS tools in detail with plenty of code samples which help to jump-start for newbies. Initially, it starts with slow pace but covers more advanced topics in later chapters such as "Accessing Heterogeneous Data", "SSIS Extension and Administration", "Integration with WMI and External Applications" etc. It provides the real practical experience while working with programmatic examples. I would recommend this as a great reference book even for expert SSIS developers.
... with many books in the series it represents a good overview of SSIS Oct. 29 2014
By Michael Patterson - Published on
Format: Kindle Edition Verified Purchase
I am about halfway through the book and as with many books in the series it represents a good overview of SSIS. There are some relatively minor edits in some of the examples. However overall, it is a good starting place.