Data Transformation Services (DTS)
is a set of objects and utilities
to allow the automation of extract, transform and load operations to or from a database.
The objects are DTS packages and their components, and the utilities are called
DTS tools. DTS was included with earlier versions of Microsoft SQL Server, and was
almost always used with SQL Server databases, although it could be used independently
with other databases.
DTS allows data to be transformed and loaded from heterogeneous sources using OLE
DB, ODBC, or text-only files, into any supported database. DTS can also allow automation
of data import or transformation on a scheduled basis, and can perform additional
functions such as FTPing files and executing external programs. In addition, DTS
provides an alternative method of version control and backup for packages when used
in conjunction with a version control system, such as Microsoft Visual SourceSafe.