Define DTS service in SQL Server.
- DTS stands for Data Transformation Services.
- It is used to import and export data between heterogeneous data source.
- A DTS package can not only transfer data from a table to another, but can also specify a query as a source of data.
- It is a set of graphical tools and programmable objects which lets you extract, transform and consolidate data from disparate sources into single or multiple destinations.
Following table shows the important information about DTS tools, features and concepts.| Topic | Description |
| DTS Basics | It describes the capabilities of DTS and solves the business problems. |
| DTS Tools | It describes the graphical tools supplied with SQL Server 2000 which is mostly used to build the DTS package. |
| DTS Package Elements | It describes the main components of a package, such as DTS tasks and transformations. |
| Sharing Meta Data | It explains how to use SQL Server 2000 Meta Data Service with DTS to track package data in a data mart or data warehouse. |
| Managing a DTS package | It explains the basics of package management, including creating, editing, saving, deleting and executing packages. |
