Microsoft SQL Server 2012 Integration Services (Developer Reference)

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.

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

SSIS Development (Custom Tasks, etc. ) should be covered more completely.I can't complain though... the book is not for .NET developers.

It doesn't matter how good or bad the content is when in the eBook form there is no table of contents. The book is worthless in electronic form.

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.

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.

I really liked this book as it covers a wide range of useful topics in a systematic way. Having hands on samples makes the topics easy to understand and to grasp very clearly .Particularly the trouble shooting of ssis - package failures/ performance issues/ data issues is explained in a good way. A good book to refer.

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.

Look like old book.

But not so great for SSIS Development. If you're going to administer an SSIS system, then this book is for you. If you're developing for SSIS there's better books than this.

The books content is not par with Microsoft standard. It's better to read from Microsoft Website.

So nice book i have learnt alot