Many organizations need to centralize data to improve corporate decision-making. However, this data can be stored in a large variety of formats in a number of different places. Using Data Transformation Services (DTS), you can import and export data between multiple heterogeneous sources using an OLE DB-based architecture. You can transform data to build a data warehouse from an online transaction processing (OLTP) system during this process. In addition to tabular data, DTS allows you to transfer database objects such as indexes and stored procedures between computers running Microsoft® SQL Server™ version 7.0.
| Topic | Description |
|---|---|
| Understanding Data Transformation Services | Describes how you specify the work to be performed as part of the import, export, or transformation process. |
| Data Transformation Services Package | Describes a set of tasks to be performed in a series of steps; packages are the main DTS objects. |
| Data Transformation Services Import and Export Wizards | Describes how these wizards allow the user to interactively import, export, or transform data, transfer SQL Server 7.0 database objects, and create DTS packages. |
| DTS Designer | Describes how this DTS component allows experienced users to create complex DTS packages using graphics tools on a designer work surface. |
| Advanced DTS Topics | Describes advanced DTS features for use in complex data warehousing scenarios, including data driven queries, table lookups, and the capability to query an existing package. |