O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

NOTE

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required