Product DescriptionAs a practical guide for Integration Services ETL development, this book shows you ways to implement your ETL solution requirements from the data to the administration and everything in-between. Each chapter begins with a review of pertinent ETL concepts and moves into working those out into a design with multiple examples and related Integration Services features with the end goal of putting it all together to get a solution.
Customer Reviews
Average Rating:
Rating: - Forged from developing production ETL systems
This book was written a year or so after SSIS 2005 was released. It has some good best practice information forged from developing production ETL systems with SSIS. Some of the books released at the time of the product release lacked that perspective. I recommend this book.
Rating: - Misleading title. Might be good for BI+OLAP work, but lousy as a generalist reference.
Understand the 2 stars - they have nothing to do with the value or not of this book as a guide to doing Business Intelligence work with SSIS. I have _no_ opinion on that subject.
What I bought this book for was as an SSIS reference, for an ETL project I am working on. Now, if this book was titled "Advanced _Business_ _Intelligence_ using SSIS" I wouldn't have bought it. I researched this book in advance, and might have bought the companion Professional SQL Server 2005 Integration ... Read More
Rating: - perfect addition to BOL
there is a lot of advanced features of SSIS that I needed to learn, that BOL and Google seraches were not helping with. This book was a great help.
It is advanced, and not meant to be your primary resource or used for learning SSIS.
Rating: - Don't try the samples
There are lots of 5-star books with great content, but with poor samples. Unfortunately, this is one of those books.
Did anybody try the samples of Chapter 3? The sample of Figure 3-26 returns many records back (not empty as shown in the book), maybe because there is millisecond in the modified date field; the sample of Figure 3-27 does not work at all, because SSIS complains the value of timestamp field can not be assigned to that variable; the sample of figure 3-32 has no required ... Read More
Rating: - Definitely for experts
I tried to dive right into this book as my first exposure to SSIS 2005. I hate combing through tons of beginner stuff. Well, it was definitely for experts. I only made it through 3 chapters and gave up. I purchased the Proffessional companion title to this and got a much better foundation. This Expert book has helped me extend my knowledge of what I learned in the Professional book and perform some really cool automation in my projects.
I do not recommend this as your first exposure. ... Read More
- Forged from developing production ETL systems
- Misleading title. Might be good for BI+OLAP work, but lousy as a generalist reference.
- perfect addition to BOL
- Don't try the samples
