Automotive Holiday Deals Books Holiday Gift Guide Shop Men's Athletic Shoes Learn more nav_sap_SWP_6M_fly_beacon Prime Music Sweepstakes egg_2015 All-New Amazon Fire TV Get Ready for the Winter Gifts for Her Find the Best Purina Pro Plan for Your Pet Amazon Gift Card Offer cm15 cm15 cm15 $30 Off Amazon Echo $30 Off Fire HD 6 Kindle Cyber Monday Deals BestoftheYear Shop Now HTL
Microsoft SQL Server 2012 Integration Services and over one million other books are available for Amazon Kindle. Learn more

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

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

Buy New
In Stock.
Ships from and sold by Gift-wrap available.
Microsoft SQL Server 2012... has been added to your Cart
Sell yours for a Gift Card
We'll buy it for $13.01
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

11 customer reviews

See all 2 formats and editions Hide other formats and editions
New from Used from
"Please retry"
"Please retry"
$44.75 $44.09

Take an Extra 30% Off Any Book
$44.99 FREE Shipping. In Stock. Ships from and sold by Gift-wrap available.

Frequently Bought Together

  • Microsoft SQL Server 2012 Integration Services: An Expert Cookbook
  • +
  • Professional Microsoft SQL Server 2012 Integration Services
  • +
  • Knight's Microsoft SQL Server 2012 Integration Services  24-Hour Trainer
Total price: $112.42
Buy the selected items together

Special Offers and Product Promotions

  • Take an Extra 30% Off Any Book: Use promo code HOLIDAY30 at checkout to get an extra 30% off any book for a limited time. Excludes Kindle eBooks and Audible Audiobooks. Restrictions apply. Learn more | Shop now

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

Looking for the Audiobook Edition?
Tell us that you'd like this title to be produced as an audiobook, and we'll alert our colleagues at If you are the author or rights holder, let Audible help you produce the audiobook: Learn more at

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.6 pounds (View shipping rates and policies)
  • Average Customer Review: 3.8 out of 5 stars  See all reviews (11 customer reviews)
  • Amazon Best Sellers Rank: #1,225,693 in Books (See Top 100 in Books)

More About the Authors

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

Customer Reviews

Most Helpful Customer Reviews

6 of 6 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.
Sorry, we failed to record your vote. Please try again
Report abuse
5 of 5 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.
Sorry, we failed to record your vote. Please try again
Report abuse
3 of 3 people found the following review helpful By Ralph Carracedo on December 14, 2014
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.
1 Comment 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
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.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Microsoft SQL Server 2012 Integration Services: An Expert Cookbook
This item: Microsoft SQL Server 2012 Integration Services: An Expert Cookbook
Price: $44.99
Ships from and sold by

Want to discover more products? Check out these pages to see more: sql server integration services tuning, integration services