Select Source Tables and Views

DTS Import/Export Wizard Help

DTS Import/Export Wizard Help

Select Source Tables and Views

Use this dialog box to specify the tables and view to be copied to the destination.

Options

Table(s) and View(s)

View the tables and views that are available for copying to the destination. If you select a source and perform no other action, you will copy the schema and data from the source without changes.

...

Display the Column Mappings and Transformations dialog box, where you specify which destination columns are to receive source data, edit script code to customize the transfer at the record level, and edit the SQL code required to create the destination table.

Preview

Preview the source data to verify it before running the Data Transformation Services (DTS) package. Click Back to return to previous dialog boxes, where you can make corrections that will produce the appropriate data.