EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

DTS Packages


In SQL Server 2000, Data Transformation Services (DTS) is a component built to take data from one OLE DB data source, perform certain operations and store it in a destination OLE DB data source. DTS consists of packages which define a particular set of work that forms a logical work item. DTS Packages contain multiple connections to data sources, tasks to be performed, workflows. Examples of tasks include copying data from source to destination connections, transforming data from a source connection and placing the transformed data in the destination connection, executing a set of Microsoft ActiveX scripts or Transact-SQL statements against a connection.

 

In SQL Server 2005 (and higher), Integration Services (SSIS) packages are provided for data warehousing purposes.

 

SQL Manager for SQL Server provides running Data Transformation Services (DTS) packages that were developed by using SQL Server 2000 tools. These can be run in SQL Server 2005 and higher, alongside Integration Services (SSIS) packages.

 

Importing DTS Packages

 

To import DTS Package:

  • right-click DTS Package node (within the Server Objects branch) or any object within this node in the DB Explorer tree and select the Tasks | Import DTS Package... item from the context menu.

 

Exporting DTS Packages

 

To export DTS Package:

  • right-click DTS Package node (within the Server Objects branch) or any object within this node in the DB Explorer tree and select the Tasks | Export DTS Package... item from the context menu.

 

Running DTS Packages

 

To run DTS Package:

  • right-click any object in the DTS Package node (within the Server Objects branch) in the DB Explorer tree and select the Tasks | Run DTS Package... item from the context menu.

 

To import, export, run DTS Packages you can also use the context menu and the Navigation bar of DTS Packages manager. You can view package properties in the DTS Package properties dialog.