CDN$ 50.71
  • List Price: CDN$ 65.99
  • You Save: CDN$ 15.28 (23%)
Only 1 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 3 images

Professional Microsoft SQL Server 2014 Integration Services Paperback – Apr 21 2014

5.0 out of 5 stars 1 customer review

See all 3 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
"Please retry"
CDN$ 50.71
CDN$ 28.58 CDN$ 57.24

Harry Potter and the Cursed Child
click to open popover

Frequently Bought Together

  • Professional Microsoft SQL Server 2014 Integration Services
  • +
  • Professional Microsoft SQL Server 2012 Reporting Services
  • +
  • Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX
Total price: CDN$ 150.74
Buy the selected items together

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

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

Product Details

  • Paperback: 912 pages
  • Publisher: Wrox (April 21 2014)
  • Language: English
  • ISBN-10: 1118850874
  • ISBN-13: 978-1118850879
  • Product Dimensions: 18.8 x 4.2 x 23.6 cm
  • Shipping Weight: 1.5 Kg
  • Average Customer Review: 5.0 out of 5 stars 1 customer review
  • Amazon Bestsellers Rank: #49,367 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

  • See Complete Table of Contents

Product Description


This book is suitable for both developers that are new to SSIS development, and experienced developers looking for a more complete understanding. I highly recommend it. (I Programmer, July 2014)

From the Back Cover

A complete guide to Microsoft SSIS, updated for the 2014 release

Renowned SQL Server MVP Brian Knight and his expert co-authors teach you best practices for using all of the features of Microsoft SQL Server Integration Services (SSIS), including the latest enhancements introduced with the 2014 release of SQL Server. In addition to technical updates and additions, the authors also add a new set of best practices for effective use of SSIS, more case studies, and tutorial examples to illustrate advanced concepts and techniques.

Professional Microsoft SQL Server 2014 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
  • Details best practices for manageability and scalability

See all Product Description

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

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

Top Customer Reviews

Format: Paperback Verified Purchase
Thank you! Product as described, Fast shipping!
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) HASH(0xa4bb2edc) out of 5 stars 11 reviews
13 of 14 people found the following review helpful
HASH(0xa77bb93c) out of 5 stars Written by high level experts; too wordy for its own good. Nov. 10 2014
By Jaewoo Kim - Published on
Format: Paperback
Some books are far better off providing visualization rather than more words. This book seems to have focused on having as many words as possible to fill up a thick book. I would like to have seen more downloadable code examples, which was sufficient in quantity and quality, but still not enough to my liking.

Is this book comprehensive? I think it is the most comprehensive book on SSIS I have read. Would I want to read this book from the beginning to end? No, and I am a very fast reader.

On the bright side, the book is written by SSIS experts with many years of experience and its shows. They cover not only SSIS but many parts of data warehousing, SSAS, T-SQL, and even C# codes. I think this is the most authoritative book on SSIS I have read.

I also think the book could have included hypothetical problem and solutions (although it implicitly provides that in the code samples).

It is too bad, the book could have been just as effective with about half the words.

1)Written by group of SSIS experts.
2)Comprehensive coverage of SSIS and related data warehousing and SSAS concepts.
3)Detailed coverage. This isn't just an overview.

1)Wordy. It is as if the authors were paid by the number of words they have written.
2)Lacking in specific hypotheticals and solutions. For me, I want to know how to use SSIS to solve a problem, not necessarily on how SSIS works to an exacting detail.
3)Scant coverage of MDX and DMX. Yes, very few organizations use them, but I also think they could have covered it a little bit.
7 of 8 people found the following review helpful
HASH(0xa77bb990) out of 5 stars Outstanding Integration Services resource June 2 2014
By Faiz Farazi - Published on
Format: Paperback
Brian Knight’s Professional Microsoft SQL Server 2014 Integration Services is an excellent resource for IT professionals needing to make effective use of this ETL tool.I had worked with SSIS 2008 but found it somewhat clumsy and lacking in completeness. Now wanting to get back into SSIS with version 2014 I was looking for a resource to help me go deep and make it really a great work tool. This book did the trick. Brian Knight emphasis and explanations on the data flow task and Joining Data were very helpful.
7 of 9 people found the following review helpful
HASH(0xa77bbdc8) out of 5 stars Gain a professional level of understanding of SSIS July 7 2014
By Ian Stirk - Published on
Format: Paperback

I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.

A popular SQL Server Integration Services (SSIS) book receives an upgrade for 2014 - how does it fare?

This is a revised version of a popular SSIS book, updated for SQL Server 2014. SSIS allows you to extract, transform and load (ETL) data. The tool can be used by a variety of users (developers, DBAs, and casual users) and at various levels of expertise.

The introduction highlights the importance of SSIS in transforming and moving data, in a speedy manner. Compared with other related products (e.g. Informatica and DataStage), SSIS is cheap, in that it comes free with SQL Server - similar products can cost many thousands of dollars. The book's initial chapters are aimed at developers that are new to SSIS, while the later chapters contain patterns and practices targeted at more experienced developers.

Chapter 1 Welcome to SQL Server Integration Services
The chapter starts with a short history of SSIS, with its roots in Data Transformation Services (DTS), evolving into SSIS in SQL Server 2005. Each successive new version of SQL Server typically adding new features and enhanced functionality, this was especially so of SQL Server 2012.

The Import and Export Wizard is introduced as an entry point into SSIS, allowing simple movement and transformation of data. For more complex solutions, SQL Server Data Tools (SSDT) is used, this is where most SSIS work is done.

The architecture of SSIS is outlined, with the major components being:
*Packages (comparable to executables, containing workflow and business logic)
*Control Flow (the brain of the package, orchestrating workflow)
*Data Flow (heart/pump, moving and transforming data from source to destination)
*Variables (allow dynamic evaluation of expressions and decision making)
*Parameters (like variables, allow package to be dynamic)
*Error Handling and Logging (useful for troubleshooting and auditing)

An outline of the common Control Flow tasks is given, together with common sources, destinations, and transformations used by the Data Flow component. Finally, an overview of the various editions of SQL Server is given.

This chapter puts SSIS into context, and provides an overview of what to expect in the rest of the book. The summary list of Control Flow tasks, together with the summary list of Data Flow sources, destinations and transformations, are useful for getting an early understanding of the potential functionality of SSIS. The chapter contains useful links to more detailed chapters. Helpful examples are provided, together with plenty of screenshots and an easy reading style (as it is throughout the book).
This book aims to take you to a professional level of understanding of SSIS, and I think it succeeds admirably. The book is an easy read, the authors have taken the time to explain things in a clear yet concise manner. The book assumes no previous knowledge of SSIS, and will take your level of understanding to around level 8 (out of 10). The book as a whole has a good flow between chapters.

The book is replete with step-by-step examples, with good use of screenshots to further aid understanding. Most of the examples are based on the sample Microsoft databases, allowing you follow along, any additional files can be downloaded from the publisher. There's a helpful (if short) summary at the end of each chapter, and useful links between the chapters. There are plenty of incidental tips introduced during the discussions (e.g. use the Union All transform as a dummy destination).

As the authors admit in Chapter 1, SSIS in SQL Server 2014 is very similar to SSIS in SQL Server 2012, very little has changed. Indeed, perhaps 95% of this book is the `same' as the SQL Server 2012 version of this book. I would suggest if you have the 2012 version of the book you don't need this version. Similarly, if you deal with SQL Server 2012 and don't have an SSIS book, you could use this 2014 version of the book. Perhaps publishers should produce a book(let) of changes that exist between the two book versions too.

However joyous it may be for the authors, I found the religious references in the acknowledgments both comical and disconcerting (e.g. I want to thank god). If you swap `god' with Huitzilopochtli or Zeus you'll understand what I mean.

This book is suitable for both developers that are new to SSIS development, and experienced developers looking for a more complete understanding. I highly recommend it.
4 of 6 people found the following review helpful
HASH(0xa6bbd1a4) out of 5 stars Not a good book for beginners or intro into SSIS July 26 2015
By CW - Published on
Format: Paperback Verified Purchase
I bought when I was new to SSIS and while this book is OK as a reference it is way too detailed for much else. You would be hard pressed to read it in sequence. I have spent the last 20 years working in DW environments and used many of the mainstream BI and ETL tools out there. I am impressed with SQL Server and SSIS but this book is not the way to be introduced to SSIS. Yes the authors know their stuff, but they try and cram it all into this book from page one. They would be better off with some simple basics using screen shots to build your first flows and then provide quick guides to deeper functions. I ended up learning SSIS through an introduction class, msdn and blogs, plus some YouTube videos. This book rarely gets used now. I would not recommend it for beginners.
2 of 3 people found the following review helpful
HASH(0xa6bbd150) out of 5 stars Too much detail on the parts that don't matter Nov. 23 2015
By LA - Published on
Format: Paperback Verified Purchase
Too many pages spent on the "Duh" and "Here is how to follow a menu"
Was expecting to be more of a demonstration/introduction of the power of the system, not just a monstrous 'help' dialogue.