Only 1 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Microsoft SQL Server 2000... has been added to your Cart
+ CDN$ 6.49 shipping
Used: Good | Details
Condition: Used: Good
Comment: **SHIPPED FROM UK** We believe you will be completely satisfied with our quick and reliable service. All orders are dispatched as swiftly as possible! Buy with confidence!
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Microsoft SQL Server 2000 DTS [Data Transformation Services] Paperback – Dec 12 2000

3.3 out of 5 stars 6 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
"Please retry"
CDN$ 51.99
CDN$ 21.20 CDN$ 0.98

Harry Potter and the Cursed Child
click to open popover

Special Offers and Product Promotions

  • You'll save an extra 5% on Books purchased from, now through July 29th. No code necessary, discount applied at checkout. Here's how (restrictions apply)

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Product Details

  • Paperback: 744 pages
  • Publisher: Sams Publishing; 1 edition (Dec 12 2000)
  • Language: English
  • ISBN-10: 0672320118
  • ISBN-13: 978-0672320118
  • Product Dimensions: 18.5 x 4.1 x 22.9 cm
  • Shipping Weight: 1.2 Kg
  • Average Customer Review: 3.3 out of 5 stars 6 customer reviews
  • Amazon Bestsellers Rank: #77,280 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

  • See Complete Table of Contents

Product Description

From the Author

The inclusion of DTS makes SQL Server a more powerful platform for data warehousing and other uses as an enterprise database. DTS in SQL Server 2000 provides much more functionality and convenience than DTS in SQL Server 7.0.

The Transform Data task gives you a convenient, flexible, and fast method to move data. This task gives you control of each row of data. At the same time, the Transform Data task can use an extremely fast bulk insert to load batches of records at a time into SQL Server.

What do you have to know in order to begin using DTS?

Not much. You can use the DTS Import/Export Wizard and easily create a DTS package.

But to really be effective with DTS, you need to learn about DTS packages, connections, tasks, and steps. You need to be able to combine the set-oriented logic of SQL with the programmatic logic of a scripting language. You need to learn the wealth of possibilities provided by the 21 different built-in tasks.

My book tells you the purpose for each of the tasks and its properties. I have also provided numerous code samples to help you get started with your scripts and programming. You can do a lot with DTS without buying a book about it. But I hope my book can help you learn how to use this great tool more quickly and more effectively.

One note - the text of the book refers repeatedly to a CD, which was not included with the book. All the source code is available on the publisher's web site. The source code includes a version of the Local Cube Task, a custom DTS task that can be used to automate the creation of local cube files from an Analysis Services cube. You can find a current version of the task on the localcubetask web site. You can also sign up on the web site to receive code updates and new insights into using DTS.

From the Inside Flap


Use Data Transformation Services (DTS) with a variety of data sources.

Write scripts to customize data transformations

Integrate DTS with XML.

Design data marts and load them with DTS.

Integrate DTS with VB applications.

Use the DTS wizards for rapid development of DTS packages.

Integrate DTS with the OLAP and data mining capabilities of Analysis Services.

Use the transformation tasks, data movement tasks, and control tasks.

Control the flow of events and set up looping in your DTS packages.

Use the multiple phases of the transformation tasks.

Manipulate hierarchical rowsets with the Parallel Data Pump task.

Manage packages with Visual Basic and Transact-SQL stored procedures.

Handle package and transformation errors.

Develop high-performance DTS packages.

Integrate DTS with Meta Data Services.

Create custom tasks in Visual Basic.

Create custom transformations in Visual C++.

See all Product Description

Customer Reviews

3.3 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See all 6 customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
SQL Server 2000 DTS by Peterson.
As much as DTS is used in the thousands of SQL Server (7 & 2000) implementations out there, for tasks as simple as copying or moving tables from one database to another, there is VERY little documentation on the product... that is, documentation that explores and explains the details and myriad of options available for use within the tool. I am a strong believer that because of this lack of documentation this wonderful tool is underutilized and regarded as a mystery to many.
Here comes Mr. Peterson and gives us this great resource to help us better understand the intricacies of the tool, in a very logical and organized manner with the respect and level of content that a professional (such as is the target audience for this book) needs and appreciates.
Chapters are specific, to the point and generally develop some sort of simple scenario that puts the theory into practice. The author constantly points out the areas where the 2000 version of the tool is enhanced over the previous version shipped with SQL Server 7. I also like the plethora of code samples and the side-by-side solution alternative presented with each code snippet vs. its UI counterpart implementation.
The first two chapters alone are enough to get you started and excited about using the tool and it could stand on it own as a great article!, whereas the rest of the book presents a more detailed view of all the additional features as well as a very complete tutorial on coding DTS solutions.
The book is a great sole reference and guide for DTS, partially because of the lack of "competition" but mostly because its content is valuable, complete and easy to follow. This text has been with me for almost 2 years and to this day it still helps me out when I'm in need.
Read more ›
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse
Format: Paperback
SQL Server DTS gives a very good review all the DTS packages available in SQL Server 2000. Each package is presented with an overview of it's features, a dicussion of the package options and examples of using the package. In most cases, there are nice examples of how to use (and extend) the package programmatically (using Visual Basic).
The book is useful beyond learning about DTS because it explains how to use DTS effectively. The book frequently comments on performance implications of certain features and gives the tradeoffs between certain packages.
If there is a downside, it is that the book doesn't cover the DTS object model too well. The code examples are very good, but if you want to delve deeper you'll find yourself sifting through the DTS online documentation. However, I'm not sure this is a downside. Leaving this information out allows the book to stay on topic without drifting off into reference material.
Overall a very good both for those looking to learn about DTS and use it effectively.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse
Format: Paperback
I liked the book. It has helped me in any DTS task I undertake. The book gives you everything you need to perform DTS manipulation. Like every book, it cannot provide you with "everything". Therefore, for starters, try this book to give you the knowledge that you need to be a DTS power user. Then supply it with groups, MDSN and Books Online if needed. There is no need to buy any other book.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse