Shop now Learn more Shop now Shop Clothing clo_fly_aw15_NA_shoes Shop All Shop All Amazon Fashion Cloud Drive Photos Shop now Shop Fire TV Shop now Shop Fire HD 6 Shop Kindle Paperwhite Shop now Shop Now Shop now

Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Image not available

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook [Kindle Edition]

Reza Rad , Pedro Perfeito
4.0 out of 5 stars  See all reviews (4 customer reviews)

Print List Price: £27.99
Kindle Price: £20.39 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £7.60 (27%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.


Amazon Price New from Used from
Kindle Edition £20.39  
Paperback £27.99  
Celebrate 5 Years of Kindle
Celebrate 5 Years of Kindle: Bestsellers for 99p
For five days starting 2nd September, 2015 we'll reveal a selection of bestsellers from the last 5 years, on sale for 99p for one day only -- come back each day to see the next selection of favourites for 99p. >Shop now

Book Description

This book is written in a simple, easy to understand format with lots of screenshots and step-by-step explanations. If you are an SQL database administrator or developer looking to explore all the aspects of SSIS and need to use SSIS in the data transfer parts of systems, then this is the best guide for you. Basic understanding of working with SQL Server Integration Services is required.

Customers Who Bought This Item Also Bought

Page of Start over
This shopping feature will continue to load items. In order to navigate out of this carousel please use your heading shortcut key to navigate to the next or previous heading.

Product Description

About the Author

Reza Rad is a Senior Microsoft BI Consultant, Author, and Trainer. He has a BsC in Computer engineering; he has more than 10 years' experience in programming and development mostly on Microsoft technologies. He got his Microsoft MVP in SQL Server in 2011 for his dedication in SSIS. He is known as Reza Rad in online communities and forums, his official Name is Abolfazl Radgoudarzi. Reza has worked on Microsoft BI suite for more than six years; he is a SSIS/MSBI/.NET Trainer and also a software and BI Consultant at some companies and private institutes. He was co-author of the SQL Server MVP Deep Dive Volume 2. His articles on different aspects of technologies especially on SSIS can be found on his blog:, his direct email address is

Pedro was born in 1977 in Portugal and currently works as BI Senior Consultant and Developer at Novabase. He's also an invited teacher in master and postgraduate BI degrees, by IUL-ISCTE (Lisbon) and by Universidade Portucalense (UPT-Porto) respectively. He received in 2010 and 2011 the Microsoft award "Microsoft Most Valuable Professional" (MVP) for all his dedication and contribution helping theoretical and practical issues in the various BI communities and he’s also co-author of the SQL MVP Deep Dives book – 2Edition.

He has several Microsoft certifications including MCP, MCSD, MCTS-Web, MCTS-BI and MCITP-BI and also worldwide certifications in the area of BI provided by TDWI/CBIP (The Data Warehouse Institute – He's currently preparing his PhD degree on BI. For further details you can also visit his personal blog at or even contact him directly at

Product details

  • Format: Kindle Edition
  • File Size: 26782 KB
  • Print Length: 566 pages
  • Page Numbers Source ISBN: 184968524X
  • Publisher: Packt Publishing (24 May 2012)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B007FH3RHE
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Enhanced Typesetting: Not Enabled
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Bestsellers Rank: #417,248 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Authors

Discover books, learn about writers, and more.

Customer Reviews

5 star
3 star
2 star
1 star
4.0 out of 5 stars
4.0 out of 5 stars
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
4.0 out of 5 stars For the SSIS Developer - Nice useful cookbook 15 July 2012
Nice Cookbook for the experienced SSIS developer. It has useful recipes which I feel do encompass most scenarios one would encounter in the "world" of SSIS development. It will be an asset in any SSIS Library.

I think this book could be used by Learners of SSIS (2012) as well as by experienced SSIS developers, in as much the best way to learn a product is by practical experience and some of the "cook book" recipes tend to be on basics and useful for gaining practical experience.

However (experienced and beginners alike) be aware that I found it difficult to follow some of the recipes from scratch in my test lab; I feel that a certain assumptions have be made on how things work in SSIS and some of the recipes have been written by someone with very knowledgeable SSIS experience, so no "dumbing down" and I think certain steps in the recipes were omitted or not explained clearly. I marked it down to 4 stars because of this factor. A saving grace is they do provide their downloadable solutions from the PACKT publishing site so at least you can get at a correct solution and this I found useful as I could re-engineer the recipes.

Over all, very pleased with the book and I am glad it is in my Library.
Comment | 
Was this review helpful to you?
4.0 out of 5 stars A good book for DBA's who dabble with SSIS 27 July 2012
Format:Kindle Edition
As someone who has only previously used SSIS 2008 for very simple ETL's I found this book insightful and useful. The early chapters do a good job of explaining Control Flow and Data Flow tasks, their purposes and how to use them. It also explains the basics of SSDT and what has changed since BIDS and SSIS 2008.

I did not dwell on the mid chapters 6-8 as they walk through some of the more complex parts of SSIS that are very useful to ETL developers and good things to understand for the rest of us. Instead I skipped ahead and found Chapter 9 usefully explains the various ways that can now be employed to deploy SSIS packages through environments. The new Project Deployment Model differs from the older Package Deployment Model you may have been familiar with and Chapter 9 does a very good of explaining this and how to use the new model and the SSIS Catalog. The examples do a good job of demonstrating this and will be of great help when trying to decide which method you want or need to standardise your release processes for.

Chapters 10 and 13 are definitely ones I will be coming back to as and when I have SQL 2012 servers going live and will need to be able to migrate older 2008 packages to them. They also give good examples on how to ensure that packages are in a supportable state with decent error handling.

Overall a very good book and definitely a good addition to the book shelf that I would recommend for DBA's as well as ETL developers.
Comment | 
Was this review helpful to you?
4.0 out of 5 stars An excellent go to resource 30 July 2012
This cookbook is well illustrated, written and informative with step by step examples for real world solutions, In depth explanations are provided at the end of each example.

The book includes performance tips, best advised practises and new features in SSIS 2012 (Upsert, Change Data Capture, Undo/Redo,Shared Connection Managers etc).

The Bottom Line: An excellent go to resource for the new BIDS Developer or experienced Bids Developer / DBA looking to explore new features or improve current package performance this book has something for you.
Comment | 
Was this review helpful to you?
Bought this book while I was preparing for my "70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012" certification. It does not cover all the topics(such as DQS, MDS) required for the exam, but all the SSIS 2012 features are explained clearly with Step by step examples. Enjoyed reading through and practicing.

E-book was given free when hard copy was bought from "PACKT publishing" website. Hard copy arrived after I finished my exam(3 weeks after ordering). It was the e-book that I had read through.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 3.8 out of 5 stars  11 reviews
6 of 6 people found the following review helpful
4.0 out of 5 stars A worthwhile investment for any SSIS developer 13 July 2012
By Wayne - Published on
I first came into contact with Microsoft's ETL tools in Windows Server 2000. This tool was called DTS and well, it did the job. With the release of 2005 Microsoft completely overhauled SQL Server and brought out SSIS. This release is what helped propel SQL server into the Enterprise market. I am currently a Data Warehouse Consultant so will be reviewing this book with a perspective of an Agile Data Warehouse Developer.

The book starts of giving a brief history of the SSIS tool and its heritage. This book's target audience would be those who have used SSIS and are looking for deeper knowledge or more experienced SSIS developers looking for goto manual. As this is a cookbook the chapters then move on relevant subject areas and have recipes based on those areas.

It covers a fair bit of the components available in the toolbox. It tells you what this component is used for and then gives a recipe for using that component. I can see this book being the reference manual when building packages and it answers that, how do I do that again, thought.

The sections on scripting & logging are a little lite. The scripting section could have gone further into depth about what you can do from the .NET environment by offering a little more than just a mail example. However, keeping in mind this is a recipe book, there is enough for you to understand how to setup a basic script and then use the power of .NET to extend this to enable you to do tasks beyond the standard components.

I really liked the recipe for the checkpoint as I have not realised this feature was available and will ensure if I need to build SSIS packages again in the future, I refer to this recipe.

Overall this is a fantastic book at giving you the right information on how to use/do a particular task that you can then start modifying to suit your environment. I would have this book on my shelf and hope that Packt get positive feedback so they can then create an Advanced Recipes book that gives you some real world useful recipes for overcoming some of the shortfalls that SSIS may have in specific situations.
5 of 5 people found the following review helpful
5.0 out of 5 stars An Excellent Book on Data Integration with SSIS 2012 5 Aug. 2012
By Lincoln Bovee - Published on
I found this to be an excellent book for learning SSIS more thoroughly. It covers a wide variety of scenarios, including steps for troubleshooting packages and improving performance. I liked the wide variety of recipes they made available, from simple control-flow tasks, to advanced data transformations. There are also recipes for migrating packages to SSIS 2012, event handling and logging, scripting, and deploying packages to a production server. My favorite recipes were on control flow and data transformations as they covered some scenarios I have had to do in the past with DTS and I thought the recipes they provided did a good job explaining how to set those up. The authors do a great job explaining the concepts behind the recipes and their use of the numerous tasks available in SSDT (SQL Server Data Tools). A complete set of sample code and data sources are provided for all the recipes.

The very straightforward style this book is written in, using a step-by-step approach, makes it very easy to follow. I appreciated the numerous screenshots provided for each scenario. I also appreciated the number of recipes in this book. They should cover most of the real-world scenarios you will likely encounter.

If you are a novice and want to improve your SSDT and SSIS skills, or have years of experience with data integration in SQL Server, this book is an excellent resource.
3 of 3 people found the following review helpful
1.0 out of 5 stars The folks that have given this book a great review must be friends of the authors 14 Dec. 2014
By Ralph Carracedo - Published on
Format:Paperback|Verified Purchase
The folks that have given this book a great review must be friends of the authors. This book is riddled with typos and errors, misleading steps and right out incorrect information (they even have misspelled features and properties of the product). I have had to google resolutions to find alternative solutions to their exercises. Almost every single recipe has a problem, does not work as they say and there is no errata nor do they reply to the support emails they offer. The only good thing I could say about the book is that it makes you work. It makes you work hard at learning the product because the book just gives you an idea it doesn't give you the proper steps as it is supposed to. DO NOT BELIEVE the rave reviews. If you are going to purchase it be ready to figure out a lot of stuff on your own.
2 of 2 people found the following review helpful
4.0 out of 5 stars Many good recipes and reference, not an expert book 1 Sept. 2012
By Luciano Moreira - Published on
I consider myself someone skillful in the SSIS world, but since I'm constantly checking for new learning I came across this book.

The book deliver what it promises, a series of recipes to many tasks that you might be doing in the real world. It covers almost all transformation and tasks in the toolbox, providing to the reader many examples on how to use the tooling available. All the instructions are step by step, so if you are not familiar with Integration Services it should guide you nicely into the SSIS world.

Since it an series of recipes you may find it a little hard to read end to end, but the authors put a nice layout grouping recipes by control flow, data flow and other subjects, like dynamism, containers, scripting and deployment.

What I didn't like in this book: it's not an Expert cookbook as the title says, it is more focused on the average developer or DBA, who's trying to use SSIS. It mentions some advanced subject briefly, for example, custom tasks and performance, it would be better to cover that in detail (but that could be outside the scope of the book) than to provide some basic orientation. It doesn't provide you guidance on how to assemble an package using 3 or 4 recipes, the complete package design is up to you, but it gives you all the building blocks.

If you are looking for a book that teaches you linearly all the fundamental concepts of SSIS, pipeline philosophy and explore it's components, gaining insight in each of them, like learning a new language from the ground up, this book is NOT what you are looking for.

Nevertheless, this book it's a great addendum to my library, being an excellent source for quick guidance in SSIS. It will help developers and DBAs to execute many tasks in Integration Services, if not exactly, they will guide you to the answer. I can picture it in a company shelf and constantly people referring to it, checking how it's done.
4.0 out of 5 stars Great Recipe Book 22 Jun. 2014
By Tmac - Published on
Format:Paperback|Verified Purchase
I've worked through the first 9 chapters and was able to get all but one recipe to work. The one that didn't had to do with monitoring a folder for changes (like a new file appearing so that it could be processed). I used the author's code for that and still no luck, so that one requires some research and was not worth spending additional time on. Overall, I thought the recipes were a very good representation of what SSIS can do. I've been using DTS/SSIS since SQL 7, and I learned some things that made this book a wise investment. The editing could be better, but such is the case with most technical books. Also, while the instructions were usually quite direct and to the point, there was some repetition in the steps, the creation of connections in particular. For those two reasons, I give it only 4 instead of 5 stars, but this is a good book to have for anyone starting out with SSIS or someone who has used SSIS for some things but is not familiar with all the components and wants to pick up some pointers.
Were these reviews helpful?   Let us know
Search Customer Reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category