Data Transformation Services
In SQL Server database application design and development DTS = Data Transformation Services.
The DTS feature allows you to automate routines and makes it easy to extract, transform, and load data from heterogeneous sources using OLE DB, ODBC, or text-only files into any supported database. DTS can also allow automatation of data import or transformation on a scheduled basis.
DTS Packages can now be saved as Microsoft Visual Basic 6.0 code. In addition DTS provides an alternative method of version control and backup for packages when used in conjunction with the Microsoft Visual SourceSafe version control system.
Using DTS
DTS is a set of graphical toold and programmable objects that enable you to extract, transform and consolidate data from disparate sources into single o multiple destinations. By using DTS tools, you can create DTS packages that enable you to create custom data-movement solutions tailored to the specialized business needs of your organization. The capability to import and export data is among the tasks that you can perform using DTS tools and [DTS packages].
DTS Tools
DTS includes a set of tools that enable you to create, schedule and execute DTS Packages.
DTS Import/Export Wizard
Wizard used to copy data to and from an instance of Microsoft SQL Server 2000 and to map transformations on the data. Off all the DTS tools, the DTS Import/Export Wizard provides the simplest mehod of copying data between OLE DB data sources.
DTS Designer
Graphical tool used to build complex Data packages with workflows and event-driven logic. DTS Designer can also be used to edit and customize DTS packages created with the DTS Import/Export Wizard.
DTS and Enterprise Manager
Options available for manipulating DTS packages and accesing DTS package information from Enterprise Manager
DTS Package Execution Utilities
DTS Package execution utilities include the following:
- The dtswiz command prompt utility enables you to start the DTS Import/Export Wizard from a command prompt.
The dtswiz command includes a set of command switches.
- The dtsrun command prompt utility enables you to execute an existing package from a command prompt.
The dtsrun command includes a set of command switches.
- The DTS Run tility provides a set of Dialog Boxes that are used to execute an existing DTS package. You can run the DTS Run utility by executing dtsrunui from a command prompt without any command switches.
DTS Query Designer
A graphical tool used to build queries in DTS.
Related topics
OLAP Data warehouse Data mining
External links
Microsoft SQL Server: Data Transformation Services (DTS)