Convert Types without Conversion Checking (SQL Server Import and Export Wizard)

 

Updated: August 22, 2016

Applies To: SQL Server 2016

After you select the existing tables and views to copy or review the query that you provided, the SQL Server Import and Export Wizard may show Convert Types without Conversion Checking. The wizard shows this page when it can't locate one or more of the required Integration Services data type conversion and mapping files. The page includes information that helps you to understand what's missing. Click Next to consent to continue without knowing whether data type conversions will succeed. Otherwise, click Back to change your selections, or click Cancel to exit the wizard.

For info about how the wizard maps data types from source columns to destination columns, and about how the wizard uses the data type mapping files, see How the Wizard maps data types from source to destination.

The following screen shot shows the Convert Types without Conversion Checking page of the Wizard.

The problem is that the wizard can't find a mapping file that maps data types between your selected source and destination.

Convert types

System_CAPS_ICON_note.jpg Note

The info on this page doesn't include the name of the missing mapping file. Since the wizard doesn't know whether a file exists for the selected combination of source and destination, it can't provide a name for the missing file.

The info also seems to indicate that the wizard can't find the mapping file that maps provider types to SQL Server Integration Services (SSIS) data types. This is not the problem - the conversion table that maps provider types to SSIS types, DtwTypeConversion.xml, is not likely to be missing. In fact, the problem is that the wizard can't find a mapping file in the MappingFiles folder that maps data types between your selected source and destination.

After you click Next to continue without knowing whether data type conversions will succeed, 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. For more info, see Save and Run Package.

Community Additions

ADD
Show: