SQL Server DTS (Paperback)

~ Jim Samuelson (Author), M. Santos (Author), S. Miller (Author), S. Hughes (Author), Brian Sullivan (Author)

Editorial Reviews

Product Description

This book appeals to both developers and database administrators who are faced with the common situation of having to migrate or integrate data from one location into another.

While the first section of the book is designed for the beginner to DTS, it is assumed that the reader has at least basic database and programming experience. The second section is extensive coding, and is best used by someone with intermediate to advanced programming skills. The third section contains a mix of examples that will be useful to all levels of database administrators and programmers. For the readers who have been using DTS this section can be used as a reference section and help with DTS designs and usage. Unlike other resources available, this book covers data transformation in both SQL Server 7 and 2000.

From the Back Cover

CD-Rom not included.

This book appeals to both developers and database administrators who are faced with the common situation of having to migrate or integrate data from one location into another.

While the first section of the book is designed for the beginner to DTS, it is assumed that the reader has at least basic database and programming experience. The second section is extensive coding, and is best used by someone with intermediate to advanced programming skills. The third section contains a mix of examples that will be useful to all levels of database administrators and programmers. For the readers who have been using DTS this section can be used as a reference section and help with DTS designs and usage. Unlike other resources available, this book covers data transformation in both SQL Server 7 and 2000.

See all Editorial Reviews

Product Details

• Paperback: 512 pages
• Publisher: Sams; 1st edition (September 6, 2001)
• Language: English
• ISBN-10: 0735711232
• ISBN-13: 978-0735711235
• Product Dimensions: 8.8 x 7.1 x 1.1 inches
• Shipping Weight: 1.7 pounds (View shipping rates and policies)
• Average Customer Review: 3.2 out of 5 stars  See all reviews (6 customer reviews)
• Amazon.com Sales Rank: #877,267 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

7 of 7 people found the following review helpful:

2.0 out of 5 stars Problems as early as Chapter 2, November 12, 2001

By	M. K. Sherwood (Plano, Tx USA) - See all my reviews (REAL NAME)

Haven't gotten too far into this book yet. Almost gave up on the whole book just based on my experiences in Chapter 2. It is full of errors. The calls to the lookups have the parameters in the wrong order in listing 2.1 and 2.2. The instructions in chapter 2 are confusing and hard to follow. You shouldn't mix Sql 7 and 2000 together. They should be in separate sections.He references a task on page 36 that doesn't even exist. I spent a whole day trying to interpret what I was really supposed to do. I finally did so, but someone needs desperately to edit this chapter. As I get further into this book, I will update this review. Hopefully, it will improve as I go thru it.

5 of 5 people found the following review helpful:

3.0 out of 5 stars Although useful, the book needs a revision., February 20, 2002

By	V. Botvinnik - See all my reviews (REAL NAME)

This book does not provide examples of sufficient quality and number. Examples lack in the explanation of the master plan and the end result, as well as the specifics of the data models involved.In fact, those examples that are there, have errors, especially Chapter 2.
Although useful, the book needs a revision.

5 of 5 people found the following review helpful:

5.0 out of 5 stars Not for Most DBAs, December 16, 2001

By A Customer

SQL Server DTS is not for the DBA who doesn't like programming. It's for DBAs that code and developers who are familiar with SQL Server. For example, I have yet to see a better description on how to build a custom DTS task with Visual Basic - its complete & easy to follow.