Online Documentation for SQL Manager for SQL server
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.
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.
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.
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.
