Using the DTS Wizard

DTS supplies two wizards that allow a user to interactively define the tasks for a package: the Import Wizard and the Export Wizard. As with the other wizards in SQL 2000, you access the Import and Export Wizards by selecting Tools, Wizards. Alternatively, you can launch the wizards by right-clicking Data Transformations Packages and selecting New Import or New Export.


The Import and Export Wizards are essentially the same, except for some textual elements. You are not restricted to either the source being SQL Server during an export or the destination being SQL Server on the import. Whenever you need to move data from one place to the other, you can select either option, import or export. Throughout the rest of the ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.