Everything you wanted to know about DTS

These articles should provide you a very good idea about how to use
DTS in SQL 2000 Server.

Copying a Table from Oracle 10G XE to SQL 2000 Server using DTS

Using Data Transformation Services: Can We Transfer XML Data?

Using Data Transformation Services: How to Configure a Dynamic Property Task


Using Data Transformation Services, Part 12:Import From / Export To a Non-Microsoft Database

Using Data Transformation Services: Capture Recordset with a Global Variable

Using Data Transformation Services: Using Global Variables with the DTS Designer

Using Data Transformation Services: Using DTS Lookups, Introduction

Using Data Transformation Services: Package Execution Using SQL Server Agent, Introduction

Using Data Transformation Services, part 7: Transferring Files with DTS

Using Data Transformation Services, part 6: Intro to Text Transfer with Filtering

Using Data Transformation Services, part 5: Package Execution with ASP.NET

Using Data Transformation Services, part 4: Using the DTS Designer Objects (continued-2)

Using Data Transformation Services, part 3: Using the DTS Designer Objects (continued)

Using Data Transformation Services, part 2: Using the DTS Designer Objects

Using Data Transformation Services - Part 1