O'Reilly logo

SQL Server DTS by Steve Hughes,, Steve Miller,, Marcelino Santos,, Brian Sullivan, Jim Samuelson,

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required