DTS Tools

Data Transformation Services

previous page next page
Data Transformation Services

DTS Tools

Data Transformation Services (DTS) includes the following set of tools for creating, scheduling, and executing DTS packages.

Tool Description
DTS Import/Export Wizard Wizard used to copy data to and from an instance of Microsoft® SQL Server™ and to map transformations on the data.
DTS Designer Graphical tool used to build complex packages with workflows and event-driven logic. You also can use DTS Designer to edit and customize packages created with the DTS Import/Export Wizard.
DTS and SQL Server Enterprise Manager Options available for manipulating packages and accessing package information from SQL Server Enterprise Manager.
DTS Package Execution Utilities Includes the following:
  • The DTS Run utility, a set of dialog boxes used to schedule and run packages.

  • The dtsrun utility, a command prompt utility used to run packages. For more information, see dtsrun Utility.
DTS Query Designer A graphical tool used to build queries in DTS.

previous page start next page