Microsoft SQL Server 2000 DTS Step by Step

Author: Carl Rabeler
List Price: $39.99
Our Price: Click to see the latest and low price
ISBN: 0735619166
Publisher: Microsoft Press (24 September, 2003)
Edition: Paperback
Sales Rank: 16,330
Average Customer Rating: 4.33 out of 5

Buy now directly from Amazon.com - Purchase this book, safely and securely from the largest book dealer on the Internet, Amazon.com

Customer Reviews

Rating: 5 out of 5
Now I get it !
After reading the other DTS book by Chaffin, Knight and Robinson, I understood DTS, but did not understand how to apply it. If you want to learn and actually use DTS, this is the book !

Well written with very good examples that not only explain how to do real life types of problems, but explains why you are doing each step.

Thanks Carl !


Rating: 4 out of 5
Lab Guide for Beginners
PROS:
Well written, no grammatical errors found. Exercises have been well thought out and all worked flawlessly. Scripts provided to let the user "reset the world" at the beginning of any chapter. Lots of points covered and demonstrated. I have a bunch of folks on my warehouse team who know nothing about ETL. I'm going to recommend they all read this book to get started.

CONS:
This is a lab guide. Every chapter introduces a new problem to solve and demonstrates a way to solve it. Concepts are not described in much detail. Basically it's a "do this, then do this, then shazam! It Worked! Next topic..." type of book. The reader can't get lost. It is filled with many, many screen shots and redundant text. Even in the second to last chapter, after going thru the process of opening a DTS package about 50 times, the author still burns an inch and a half of paper to explain how to open a DTS package. If I made any mistakes it was due to missing a step as I try to breeze past text I've already read many, many times before. In the author's defense, I think a reader would be able to jump into any chapter without reading any introductory information. This still makes the book about twice as thick as it could be.

Read the back cover to learn exactly what is covered. In the end, you'll know how to do these things and have a good framework to continue building your own data movement application. However your knowledge will be pretty shallow. I'm now going to buy a book that explains WHY packages should be designed one way vs. another.

CONCLUSION:
I'm giving this book four stars because it's well written and true to its title. If the redundant text and supurflueus pictures were removed that make it so think, I'd have given it five. It's a great book for beginners.


Rating: 4 out of 5
The best practical coverage of SQL Server 2000 DTS
Unlike "Professional SQL Server 2000 DTS" by WROX Press, this particular book does not cover (nearly) every topic under the umbrella of Data Transformation Services. It does, however, address as many relevant aspects to DTS functionality as possible throughout the development of a 'data movement application'. Having worked with SQL Server since 1998, I can vouch for the concise teaching approach this book follows. It certainly stands out as the best book I've seen to both help introduce SQL Server professionals (especially juniors) to DTS as well as serve as a quick reference for more seasoned veterans. I can only hope future SQL Server Step-By-Step titles closely follow the great model of practical real-world relevance and clear instruction demonstrated by Mr. Rabeler's book.

Similar Products

· Professional SQL Server 2000 DTS (Data Transformation Services)
· Microsoft SQL Server 2000 Data Transformation Services DTS
· The Guru's Guide to Transact-SQL
· Microsoft(r) SQL Server(tm) 2000 Analysis Services Step by Step
· Fast Track to MDX

Return To Main Computer Book IndexSearch Our Entire Computer Book Catalog