DTS Overview

DTS Overview

SQL Server 2000

Microsoft® SQL Server™ 2000 Data Transformation Services (DTS) is a set of graphical tools and programmable objects that lets you extract, transform, and consolidate data from disparate sources into single or multiple destinations.

The following sections provide essential information on DTS concepts, tools, and features.

Topic Description
DTS Basics Describes the capabilities of DTS and summarizes the business problems it addresses.
DTS Tools Describes the graphical tools supplied with SQL Server 2000 that are used to build DTS packages.
DTS Package Elements Describes the main components of a package, such as connections, DTS tasks, and DTS transformations.
Managing a DTS Package Explains the basics of package management, including creating, editing, saving, deleting, and executing packages.
Adding Functionality to a DTS Package Explains how to build complex packages by using Microsoft ActiveX® scripts to customize a package. Describes how to join package steps to a transaction and expose package data to external sources.
Sharing Meta Data Explains how to use SQL Server 2000 Meta Data Services with DTS to track package data in a data mart or data warehouse.
Usage Considerations in DTS Describes specific data conversion and data transformation issues that can arise when using DTS.

For more information about programming with the DTS object model, see Programming DTS Applications.

© 2016 Microsoft