Column Conversion Details Dialog Box (SQL Server Import and Export Wizard)

 

Updated: February 16, 2017

If you double-click the row for an individual column on the Review Data Type Mapping page, the SQL Server Import and Export Wizard shows the Column Conversion Details dialog box. On this page you can review detailed conversion information for an individual column. This information includes the following items.

  • The data type of the column at the source and the destination.
  • The data type conversion that the wizard will perform, if a conversion is required.
  • The data type mapping files that the wizard uses to determine the required data type conversion.

The following screen shot shows the Column Conversion Details dialog box of the Wizard after the user has double-clicked on a row on the Review Data Type Mapping page. To take another look at the Review Data Type Mapping page, see Review Data Type Mapping.

In this example, you see the following things.

  • The PersonID column in the source SQL Server table is of type int. The wizard maps this type to the SQL Server Integration Services (SSIS) DT_I4 data type, which is a four-byte signed integer, by referring to the data type mapping file MSSQLToSSIS10.xml.
  • The PersonID column in the destination SQL Server table is also of type int. The wizard maps this type to the the same SSIS data type.
  • The wizard concludes, This column does not need conversion.

Column conversion page of the Import and Export Wizard

After you review the column conversion details and click OK, the Column Conversion Details dialog box returns you to the Review Data Type Mapping page. For more info, see Review Data Type Mapping.

Data Type Mapping in the SQL Server Import and Export Wizard

Community Additions

ADD
Show: