Data Transformation Services (DTS)

DTS packages are the logical components within DTS, where every DTS object is a child component of packages. They are used when a user alters data using DTS. Packages also hold connection objects, allowing packages to read data from object linking and embedding database (OLE-DB) compliant data sources. Package functionalities are organized as steps and tasks.

DTS tools within SQL Server include:

DTS transforms and loads data from heterogeneous sources like open database connectivity or text-only files into supported databases. It also automates data import or transformation on a scheduled basis, in addition to performing other functions such as executing external programs.

DTS provides version control and backups for packages when used along with version control systems.