Select Source Tables and Views (SQL Server Import and Export Wizard)

 

Updated: August 22, 2016

Applies To: SQL Server 2016

After you specify whether you want to copy an entire table or provide a query, the SQL Server Import and Export Wizard shows Select Source Tables and Views. On this page, you select the existing tables and views to copy and map them to destination tables. Optionally, you review the mapping of individual columns and preview sample data.

System_CAPS_ICON_tip.jpg Tip

If you have to copy more than one database, or database objects other than tables and views, use the Copy Database Wizard instead of the Import and Export Wizard. For more info, see Use the Copy Database Wizard.

The following screen shot shows the Select Source Tables and Views page of the Wizard after you select the Copy data from one or more tables or views option on the Specify Table Copy or Query page. In the list you see the tables and views available from the data source.

In this example, the user wants to copy the Sales.Customer table from the source to the Sales.CustomerNew table at the destination.

Select tables page of the Import and Export Wizard

The following screen shot shows the Select Source Tables and Views page of the Wizard after selecting the Write a query to specify the data to transfer option on the Specify Table Copy or Query page. In the list you see only a single row, where the item in the Source column represents the query.

In this example, the user wants to copy the query results from the source to the Sales.CustomerNew table at the destination.

Select tables page of the Import and Export Wizard

Tables and views List

Source
Using the check boxes, select from the list of available tables and views to copy to the destination. By default, the schema and data from the data source are copied without changes.

If you're providing a query, the list contains only one item with the name [Query].

Destination
Select a destination table from the list for each source table or query, or enter the name of a new table that you want the wizard to create. If you select an existing destination table, the table has to have the same columns and data types as the source table.

System_CAPS_ICON_note.jpg Note

If you pause at this point in the wizard to create a new table manually in the destination database by using an external tool (such as SQL Server Management Studio), the new table is not immediately visible in the list of available destination tables. To refresh the list of destination tables, step back to the Choose a Destination page, re-select the destination database to refresh the list of available tables and views, and then step forward again to the Select Source Tables and Views page.

Edit mappings
Optionally click Edit mappings to display the Column Mappings dialog box for the selected table. Use the Column Mappings dialog box to do the following things,

  • Review the mapping of individual columns between the source and the destination.
  • Copy only a subset of columns by selecting ignore for columns that you don't want to copy.

For more info, see Column Mappings.

Preview
Optionally click Preview to preview up to 200 rows of sample data in the Preview Data dialog box. This helps you to confirm that the wizard is going to copy the data that you want to copy. For more info, see Preview Data.

After you preview the data, you may want to change the options that you selected on previous pages of the wizard. To make these changes, on the Select Source Tables and Views page, click Back to return to previous pages where you can change your selections.

After you select the existing tables and views to copy and map them to their destinations, the next page is Save and Run Package. On this page, you specify whether you want to run the copy operation immediately. Depending on your configuration, you may also be able to save the SQL Server Integration Services package created by the wizard to customize it and to reuse it later. For more info, see Save and Run Package.

Community Additions

ADD
Show: