Microsoft SQL Server 2012 Integration Services and over one million other books are available for Amazon Kindle. Learn more
Qty:1
  • List Price: $44.99
  • Save: $4.50 (10%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Microsoft SQL Server 2012... has been added to your Cart
FREE Shipping on orders over $35.
Condition: Used: Acceptable
Comment: Item may not include associated media. Large wrinkle / bend on back cover.
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
Kindle
"Please retry"
Paperback
"Please retry"
$40.49
$40.49 $13.67
Amazon%20Web%20Services

$40.49 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.


Frequently Bought Together

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

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.


Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

  • Paperback: 564 pages
  • Publisher: Packt Publishing (May 25, 2012)
  • Language: English
  • ISBN-10: 184968524X
  • ISBN-13: 978-1849685245
  • Product Dimensions: 9.2 x 7.5 x 1.1 inches
  • Shipping Weight: 2.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.1 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Best Sellers Rank: #1,235,098 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: rad.pasfu.com, his direct email address is a.raad.g@gmail.com

More About the Authors

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

Customer Reviews

4.1 out of 5 stars
5 star
3
4 star
5
3 star
0
2 star
1
1 star
0
See all 9 customer reviews
Anyone trying to learn SSIS should get this book.
Glenn E
Overall, I thought the recipes were a very good representation of what SSIS can do.
Tmac
They should cover most of the real-world scenarios you will likely encounter.
Lincoln Bovee

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
By Dimitri Shvorob on August 12, 2014
Format: Kindle Edition
What's missing in the reviews so far is awareness of alternatives. "Microsoft SQL Server 2012 Integration Services: An Expert Cookbook" is not the only SSIS - or SS1S 2012, if you will - book on the market, and a helpful review would compare the book with its competitors. With just one other SSIS book - "Pro SQL Server 2012 Integration Services" by Rodrigues, Coles and Dye - under my belt, I am ill-qualified to provide a good survey but, for what it's worth, will recommend both books, and praise Rodrigues-Coles-Dye for a methodical, educational approach, and Rad-Perfeito for its hands-on, let's-jump-right-into-it style, and a useful collection of SSIS design templates. Disregard the "expert" in the title: the book is not advanced, and oriented at SSIS beginners.
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