Professional Microsoft SQL Server 2012 Integration Services

Brian Knight · Erik Veerman · Jessica M. Moss · Mike Davis · Chris Rock

Mar 2012 · Sold by John Wiley & Sons

About this eBook

An in-depth look at the radical changes to the newest release of SISS

Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this complex topic and provides detailed coverage of the new features of the 2012 product release. In addition to technical updates and additions, the authors present you with a new set of SISS best practices, based on years of real-world experience that have transpired since the previous edition was published.

• Details the newest features of the 2012 SISS product release, which is the most significant release since 2005
• Addresses the keys to a successful ETL solution, such as using the right enterprise ETL tool and employing the right ETL architecture in order to meet the system requirements
• Includes additional case studies and tutorial examples to illustrate advanced concepts and techniques

Professional Microsoft SQL Server 2012 Integration Services is a valuable resource that meets the demands and high expectations of experienced SSIS professionals.

Ratings and reviews

Colin Flaherty received numerous accolades for his work in mainstream journalism, and now conducts a weekly radio program with his brother in which they view politics from a left-right divide. In addition, Colin just wrote a book that is not about its seeming topic. From first glance, this book would appear to be about race riots, and while it documents them well, the real purpose of this book is to ask Americans what’s wrong with us. Why can’t we talk honestly about this situation, why can’t we talk honestly about race, and why does our media avoid mention of necessary facts? Flaherty works his magic by creating a fact pattern out of many disparate news articles, which he then compares to YouTube footage of the event, showing us what actually happened. As this is an e-book, you can follow the links yourself, which is what this book challenges you to do. He does not ever stray into racism — at all. He does not blame African-Americans, or anyone else, for this spate of black on women, homosexuals, Asians and whites. He simply points out that it is occurring and that it upsets all Americans and weakens our faith in our media, who are brushing it under the rug. Writing in clear and sometimes sarcastic prose, Flaherty speaks from his strength, which is understanding media. He links together abundant citations, all from mainstream media and many from African-American media, in order to illustrate his point.

About the author

Brian Knight is the founder of Pragmatic Works and co-founder of SQLServerCentral.com and JumpstartTV.com.

Erik Veerman is a consultant, author, trainer, and a mentor with SolidQ. His award-winning industry recognition includes Microsoft's BI Solution of the Year and SQL Server Magazine's Innovator Cup.

Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server business intelligence who has created data warehousing solutions for a variety of industries.

Mike Davis, MCTS, MCITP, is the Managing Project Lead at Pragmatic Works. He has co-authored several business intelligence books and regularly speaks at SQL events.

Chris Rock is a software developer and program manager at Pragmatic Works, where he develops custom SSIS components and software.