sutanu_halder

 Profile Answers by sutanu_halder 

• Mar 29th, 2008

 

DTS is a set of tools you can use to import, export, and transform heterogeneous data between one or more data sources, such as Microsoft SQL Server, Microsoft Excel, or Microsoft Access.

The Import/Export Wizard is for building relatively simple DTS packages, and supports data migration and simple transformations.

The DTS Designer graphically implements the DTS object model, allowing you to create DTS packages with a wide range of functionality.

DTSRun is a command-prompt utility used to execute existing DTS packages.

DTSRunUI is a graphical interface to DTSRun, which also allows the passing of global variables and the generation of command lines.

SQLAgent is not a DTS application; however, it is used by DTS to schedule package execution.