Introduction

SQL Server Data Transformation Services (DTS) is a Microsoft product that is designed to move and manipulate data. It also has a nice graphical designer. So, you can create simple or complex workflows that pull data from any number of data sources; clean, manipulate, and integrate the data; and then push the data into any number of data destinations. These repositories of data can be large DBMSs like SQL Server, Oracle, or Sybase; small DBMSs like Access, Paradox, or dBase; or even applications like Excel or Exchange. DTS also has an open COM interface. So, you can write programs that build and control your DTS Applications (called packages). DTS is an independent application and does not need SQL Server to run.

I have found that DTS ...

Get SQL Server DTS now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.