SQL Server Integration Services (SSIS) is the most widely adopted Business Intelligence (BI) component of SQL Server and the leading extraction, transformation, and loading (ETL) tool in the data warehouse industry. Written by a team of Microsoft MVPs for SQL Server, this book presents you with an array of common problems that SSIS administrators and developers face on a daily basis, and walks you through the steps necessary to solve these challenges.
Demonstrates how to solve common pitfalls involved with SSIS deployment
Shares solutions for challenges you may encounter with package deployment and storage decisions
Explores file handling and processing methods
Reviews best practices for data extraction
Covers the basic concepts and challenges of dimension table ETL and fact table ETL
Solves problems that may arise with scripting design patterns and SSIS package scaling
Discusses how to effectively scale and performance-tune SSIS packages
Wrox Problem – Design – Solution references give you solid, workable solutions to real-world development problems. Each chapter is devoted to a different scenario, analyzing every problem, examining relevant design issues, and implementing the ideal solution.
Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.
Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.
Find articles, ebooks, sample chapters and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.
Jessica M. Moss is a Microsoft MVP in SQL Server and a BI mentor, consultant, and trainer with Solid Quality Mentors.
Brian Knight is a Microsoft MVP For SQL Server and the cofounder of SQLServerCentral.com and JumpstartTV.com.
Jay Hackney is a mentor and consultant for Solid Quality Mentors, who works with SSIS to provide data warehousing and ETL solutions.
So far, I have read only the first 2-3 chapters but I must say that I really found the book very informative. Read morePublished 1 month ago by Manoj
Great book for understanding advanced SSIS patterns. Using this book I was able to come up to speed on complex packages.Published 11 months ago by Kevin
I've worked with SQL Server (97 2000 2005 2008) for 13 years. Was laid off six months ago so I have some time on my hands while I look for work, so I thought I should work on... Read morePublished 16 months ago by Michael K. Broadbent
THe prose of what I hoped to be a technical manual is really stilted as the authors try and force their commentary into a format of Problem / solution.Published 19 months ago by mtbikes
This is a truly amazing book that any SSIS developer should keep in his collection. To appreciate it, you really need to have SSIS experience already developing and supporting... Read morePublished on February 22, 2012 by silly cat
Reading this book reminds me of why I tend to stay away from Wrox books. Reading a wrox programming book is a little bit like if I wrote to you like this:
Example A:... Read more
Not just a good SSIS book... in my opinion, the best on SSIS development from solution architecture perspective. This is an excellent reference for real-life datawarehouse project.Published on December 14, 2010 by Mikhail
If you are looking for resources to ramp up your SSIS knowledge, there are two books you must read and in this order: Professional Microsoft SQL Server 2008 Integration Services... Read morePublished on November 25, 2010 by tlachev