Online Documentation for SQL Manager for SQL server

DTS Packages manager

The DTS Packages manager allows you to browse the list of DTS packages and manage them efficiently.

Using this tool you can include SQL Server 2000 DTS packages in SQL Server 2005 (and higher) data transformation solutions. A package can include both Execute Package tasks and Execute DTS 2000 Package tasks because each type of task uses a different version of the run-time engine.

To launch the tool, select the Services | DTS Packages main menu item, or right-click the host alias in the DB Explorer tree and select the Tasks | DTS Packages item from the context menu.

The list displays the existing DTS packages as a grid with the following columns: Name, Owner, Description, Create Date, ID, Size.

Click a column caption to sort items by values of this column in the ascending or the descending mode.

Right-click an item within the list to call the context menu allowing you to run a package, import a package, export the selected DTS package, or show/hide columns of the list. Using the context menu you can also export the list of DTS packages to any of supported output file formats.

DTS packages management tools are also available through the Navigation bar of the DTS Packages manager.

At the bottom of the DTS Packages manager window the info area is located. It displays common information pertaining to the selected package: creation date, version ID and description.

Hint: These properties are also available within the modal DTS Package properties dialog which is called through the DTS Package Properties... context menu item of the DTS package alias in DB Explorer.

If you need to remove a package, right-click the package in the information area and select the Delete popup menu item.