Data Transformation Services (DTS)
Definition - What does Data Transformation Services (DTS) mean?
Data Transformation Services (DTS) is a group of utilities and objects used to automatically perform extract, transform and load operations to or from databases. DTS is widely used with Microsoft SQL Server databases.
DTS was a feature of Microsoft SQL Server from version 7.0 through SQL Server 2000. It was replaced by SQL Server Integration Services (SSIS) in SQL Server 2005.
Techopedia explains Data Transformation Services (DTS)
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.
Techopedia Deals: Oracle Database 12c Administration Training Bundle
Join thousands of others with our weekly newsletter
The 4th Era of IT Infrastructure: Superconverged Systems:
Approaches and Benefits of Network Virtualization:
Free E-Book: Public Cloud Guide:
Free Tool: Virtual Health Monitor:
Free 30 Day Trial – Turbonomic: