Professional Microsoft SQL Server 2014 Integration Services and over 2 million other books are available for Amazon Kindle . Learn more
£36.99
FREE Delivery in the UK.
Only 8 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Quantity:1
Trade in your item
Get a £11.29
Gift Card.
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 2014 Integration Services (Wrox Programmer to Programmer) Paperback – 6 Jun 2014


See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
£36.99
£18.50 £25.31

Frequently Bought Together

Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer) + Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model
Price For Both: £73.98

Buy the selected items together


Trade In this Item for up to £11.29
Trade in Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer) for an Amazon Gift Card of up to £11.29, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Product details

  • Paperback: 912 pages
  • Publisher: John Wiley & Sons; 1 edition (6 Jun 2014)
  • Language: English
  • ISBN-10: 1118850874
  • ISBN-13: 978-1118850879
  • Product Dimensions: 18.8 x 4.2 x 23.6 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 423,914 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

Review

“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

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

Customer Reviews

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

Most Helpful Customer Reviews

3 of 4 people found the following review helpful By Ian Stirk on 7 July 2014
Format: Paperback
Hi,

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 follow:

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

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 3 reviews
5 of 5 people found the following review helpful
Outstanding Integration Services resource 2 Jun 2014
By Faiz Farazi - Published on Amazon.com
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.
2 of 3 people found the following review helpful
Gain a professional level of understanding of SSIS 7 July 2014
By Ian Stirk - Published on Amazon.com
Format: Paperback
Hi,

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).
.
.
.
Conclusion
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.
Written by high level experts; too wordy for its own good. 10 Nov 2014
By Jaewoo Kim - Published on Amazon.com
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.

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

Cons:
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.
Were these reviews helpful? Let us know


Feedback