Column Mappings (SQL Server Import and Export Wizard)

Use the Column Mappings dialog box to edit transformation parameters.

Note

You do not have to copy all the columns in a table when you select the Table Copy option. Select <ignore> in the Destination column of this dialog box for columns that you want to skip.

To learn more about this wizard, see Creating Packages Using the SQL Server Import and Export Wizard. To learn about the options for starting the wizard, as well as the permissions required to run the wizard successfully, see How to: Start the SQL Server Import and Export Wizard.

The purpose of the SQL Server Import and Export Wizard is to copy data from a source to a destination. The wizard can also create a destination database and destination tables for you. However, if you have to copy multiple databases or tables, or other kinds of database objects, you should use the Copy Database Wizard instead. For more information, see Using the Copy Database Wizard.

Options

  • Source
    Identifies the selected source table, view, or query.
  • Destination
    Identifies the selected destination table, view, or query.
  • Create destination table/file
    Specify whether to create the destination table if it does not already exist.
  • Delete rows in destination table/file
    Specify whether to clear the data from an existing table before loading new data.
  • Append rows to destination table/file
    Specify whether to append the new data to the data already present in an existing table.
  • Edit SQL
    Use the default statement in the Create Table SQL Statement dialog box, or modify it for your purposes. If you modify this statement, you must also make associated changes to table mapping.
  • Drop and re-create destination table
    Choose this option to overwrite the destination table. This option is only available when you use the wizard to create the destination table. The destination table is only dropped and re-created if you save the package created by the wizard and run it again.
  • Enable identity insert
    Choose this option to allow existing identity values in the source data to be inserted into an identity column in the destination table. By default, the destination identity column does not allow this.
  • Source
    View each source column for which you can set transformation parameters.
  • Destination
    Specify whether you want to ignore a column during the copy operation. You can copy only a subset of columns by selecting <ignore> in this column for columns that you want to skip. Before you map columns, you must ignore all columns that will not be mapped.
  • Type
    Select a data type for the column.
  • Nullable
    Specify whether a column will allow a null value.
  • Size
    Specify the number of characters in the column.
  • Precision
    Specify the precision of displayed data, referring to the number of digits.
  • Scale
    Specify the scale of displayed data, referring to the number of decimal places.

Change History

Release History

17 July 2006

Changed content:
  • Described how to skip columns when copying a table.