Microsoft SQL Server 2005 Integration Services Step by Step [With CDROM]

by Scott Cameron, Paul Turley, Hitachi Consulting, et al.

Teach yourself the fundamentals of SQL Server Integration Services--one step at a time. This practical, learn-by-doing tutorial delivers the guidance you need to transform and consolidate data--and... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0735624054
• ISBN13: 9780735624054
• Release Date: June 2007
• Publisher: Microsoft Press
• Length: 453 Pages
• Weight: 2.15 lbs.
• Dimensions: 1.2" x 7.3" x 9.0"

Customer Reviews

Exactly what you need if you're new to SSIS

If you're new to SSIS, this book is great. It covers the fundamentals in an easy, step-by-step way. It is true that there are quite a few errors in the book. Before diving in you should visit the errata list on the website, but that should be the habit whenever working through a technical learning book. The exercises on the accompanying CD had quite a few problems, but nothing that couldn't be worked through. As a surprise bonus, Chapter 12, "Data Warehouse Concepts", was an excellent introduction to the topic and it made me understand things I haven't been able to grasp before. Altogether, a very satisfying book.

Review of Step By Step

I found this book to be quite informative. Given that I am a first timer to SSIS, there were some useful examples. There could have been more substance around the Datawarehousing part of the book. The examples provided on the CD were shockingly packaged. There were files missing and incorrect CD's. This is disappointing given that I bought this book because it was a Microsoft Press publishing.

A great SQL Server Integration Services book for beginners

I have a project to create a data warehouse, ETL the data and report from the new data warehouse. I have no SQL server 2005 experience at all. But after I read this book and follow the book step by step. I was able to create my DW ETL data to corresponding DIM and Fact tables and created my reports from my DW correctly without any problem. This book has very clear concepts and very practical steps. If you like to learn-by-doing on SSIS. This is the book does it all.

It was not that bad at all

if you are a first time visitor to SSIS, I think its a good book. It could definitely have been better but if you need to really practice on real life scenarious, it covers them well. There might be some instructions here and there which do not exactly mirror to the latest version and not sure if those were typos vs beta version but since the SSIS interface is so intuitive it's not as bad and this book really gets you upto speed in very short time. If you are a totally new to the SSIS world, I would recommend it.