Microsoft SQL Server 2012 Integration Services (Inside Out) and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
Trade in Yours
For a 5.23 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Microsoft SQL Server 2012 Integration Services (Inside Out) on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Microsoft SQL Server 2012 Integration Services [Paperback]

Wee-Hyong Tok , Rakesh Parida , Matt Masson , Xiaoning Ding , Kaarthik Sivashanmugam
4.0 out of 5 stars  See all reviews (1 customer review)
Price: 36.99 & FREE Delivery in the UK. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 3 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 30 July? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Kindle Edition 22.31  
Paperback 36.99  
Trade In this Item for up to 5.23
Trade in Microsoft SQL Server 2012 Integration Services for an Amazon Gift Card of up to 5.23, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

20 Sep 2012 0735665850 978-0735665859 1

Build and manage data integration solutions with expert guidance from the Microsoft SQL Server Integration Services (SSIS) team. See best practices in action and dive deep into the SSIS engine, SSISDB catalog, and security features. Using the developer enhancements in SQL Server 2012 and the flexible SSIS toolset, you’ll handle complex data integration scenarios more efficiently—and acquire the skills you need to build comprehensive solutions. Discover how to:

  • Use SSIS to extract, transform, and load data from multiple data sources
  • Apply best practices to optimize package and project configuration and deployment
  • Manage security settings in the SSISDB catalog and control package access
  • Work with SSIS data quality features to profile, cleanse, and increase reliability
  • Monitor, troubleshoot, and tune SSIS solutions with advanced features such as detailed views and data taps
  • Load data incrementally to capture an easily consumable stream of insert, update, and delete activity

Frequently Bought Together

Microsoft SQL Server 2012 Integration Services + Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model
Buy the selected items together

Product details

  • Paperback: 668 pages
  • Publisher: Microsoft Press; 1 edition (20 Sep 2012)
  • Language: English
  • ISBN-10: 0735665850
  • ISBN-13: 978-0735665859
  • Product Dimensions: 23.1 x 18.8 x 3.8 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 94,504 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

About the Author

Wee-Hyong Tok is a program manager on the SQL Server Integration Services team. He has worked on several different aspects of the product. Prior to joining Microsoft, Wee Hyong was a Microsoft MVP. He is a frequent presenter at Microsoft conferences. Wee Hyong is deeply passionate about how organizations can make use of business intelligence tools to derive business insights, and make better decisions.

Rakesh Parida is a software development engineer on the SQL Server Integration Services team. He has worked on SSIS since SQL Server 2005, and was involved in many of the new features in this release, particularly ETL frameworks, data warehousing, and SSIS based solutions.

Matt Masson is a senior software development engineer on the SQL Server Integration Services team. Matt joined the team shortly after the SQL Server 2005 release, and has worked on many aspects of the product. A frequent presenter at Microsoft conferences, he is heavily involved with the SSIS community, and maintains the SSIS Team Blog (

Xiaoning Ding is a software development engineer on the SQL Server Integration Services team, which he joined in 2007. He has worked on the SSIS engine, SSIS server, security model, and in other areas.

Kaarthik Sivashanmugam is a lead software engineer on the SQL Server Integration Services team. Kaarthik joined the team during SQL Server 2005 launch and has been involved in several feature improvements to SSIS since then.

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 Not as comprehensive as I expected 29 Mar 2014
Format:Paperback|Verified Purchase
Goes into great depth on the new 2012 features.

Less information on the older tasks etc.

So seems to be geared more at upgrading knowledge of developers with previous SSIS experience. If new to SSIS It may be beneficial to read in conjunction with another book on the topic rather than expecting it to be a one stop shop for all your information needs.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 3.7 out of 5 stars  6 reviews
2.0 out of 5 stars "Noooo!" 16 July 2014
By Dimitri Shvorob - Published on
... is my measured response to the reviews entitled "Full coverage of the subject matter" and "A great reference book on SSIS 2012". It is also my warning to those considering this book as an SSIS learning aid.

You have to wonder what's going on if the book gets around to building its first SSIS package in Chapter 7: if it were a book for beginners, Chapter 2 or 3 would be a more appropriate place, and if it were a book for intermediate or advanced SSIS users, this introductory material would not be needed at all. The beginner who persevered through Chapters 1-6, learning about the upgrade procedure and the new features of the 2012 release (revised syntax of XML-format SSIS package files, anyone?), gets to load a text file into a database - and then, without a single transformation explained, is asked to implement parent-child packages, and execute them with T-SQL (!) and C# (!!). With this, core SSIS training is over, and the book moves on to more advanced or niche topics like CDC, "fuzzy" transformations and DQS, administration and performance.

It is only those more advanced topics, found in Part III, which can make this book worth a look. (The upgrade-and-new-features stuff of Chapters 3-5 can be found online). Although I did consider hiring an assassin to go after the author of Chapter 10 - when talking about SSIS 2012, it is very important to be clear about the differences between package deployment model and project deployment model, and that chapter fails this test like there's no tomorrow - the problem is not really with the individual chapters, but with lopsided, incomplete nature of their sum.

Dial M for "Microsoft Press, you sure dropped the ball with this one".
5.0 out of 5 stars Good Resource for Upgrading to SSIS 2012 17 Nov 2012
By R. Bower - Published on
Format:Paperback|Verified Purchase
Our shop currently uses SQL Server 2005 and 2008 R2, and this book is a good bridge to the new version. Good highlights on what is new and how to use the new features.
3 of 5 people found the following review helpful
3.0 out of 5 stars Quick guide to SQL 2012 IS New features 8 Nov 2012
By SQL Learner - Published on
As an Intermediate developer in SQL 2005 SSIS, I found this book useful to learn all new features in 2012. However I did not have a test environment to execute the flow. I was mostly interested to learn CDC changes and Configuration changes, which were explained well. The XML file import was explained in simple terms. Enjoyed reading this book and need to dive deep-in to understand in more detail.I would definitely recommend this book as all in one package. it starts from basis and covers all the components in SSIS.
1 of 2 people found the following review helpful
4.0 out of 5 stars Full Coverage of the subject Matter 1 July 2013
By Daniel W. Arnold - Published on
Format:Kindle Edition|Verified Purchase
SSIS Development (Custom Tasks, etc. ) should be covered more completely.
I can't complain though... the book is not for .NET developers.
1 of 2 people found the following review helpful
4.0 out of 5 stars A great reference book on SSIS 2012 24 April 2013
By Sudheer K. Maharana - Published on
It is a great book for intermediate to advanced developers in SQL Server in general or SSIS in particular. Especially I was impressed with the Chapter 3 : Upgrading to SSIS 2012 and Chapter 5: Team Development. It is always helpful to develop SSIS packages in a seamless source control environment like other SQL objects such as stored procedures, DDLs. Data cleansing chapter could have been better with little in depth explanation. However, the book is a very good reference guide for SSIS development especially if you want to know the new features of SSIS in SQL 2012, CDC, configuration, SSIS Security.
A great book indeed.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's 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