Microsoft SQL Server 2012 Integration Services and over one million other books are available for Amazon Kindle. Learn more
  • List Price: $44.99
  • Save: $4.50 (10%)
In Stock.
Ships from and sold by
Gift-wrap available.
Used: Good | Details
Sold by apex_media
Condition: Used: Good
Comment: Ships direct from Amazon! Qualifies for Prime Shipping and FREE standard shipping for orders over $25. Overnight and 2 day shipping available!
Sell yours for a Gift Card
We'll buy it for $5.47
Learn More
Trade in now
Have one to sell? Sell on Amazon
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 2012 Integration Services: An Expert Cookbook Paperback – May 25, 2012

See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
"Please retry"
"Please retry"
$40.49 $36.49

Frequently Bought Together

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook + Professional Microsoft SQL Server 2012 Integration Services
Price for both: $75.71

Buy the selected items together
If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle edition for only $2.99 (Save 82%). Print edition purchase must be sold by Amazon. Learn more.

Hero Quick Promo
12 Days of Kindle Book Deals
Load your library with Amazon's editors' picks, $2.99 or less each today only. Learn more

Product Details

  • Paperback: 564 pages
  • Publisher: Packt Publishing (May 25, 2012)
  • Language: English
  • ISBN-10: 184968524X
  • ISBN-13: 978-1849685245
  • Product Dimensions: 7.5 x 1.3 x 9.2 inches
  • Shipping Weight: 2.2 pounds (View shipping rates and policies)
  • Average Customer Review: 3.8 out of 5 stars  See all reviews (10 customer reviews)
  • Amazon Best Sellers Rank: #1,100,311 in Books (See Top 100 in Books)

Editorial Reviews

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 and 2012  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

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

3.8 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

5 of 5 people found the following review helpful By Wayne on July 13, 2012
Format: Paperback
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.
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
4 of 4 people found the following review helpful By Lincoln Bovee on August 4, 2012
Format: Paperback
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.
1 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
2 of 2 people found the following review helpful By Luciano Moreira on September 1, 2012
Format: Paperback
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.
1 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
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.
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