Microsoft SQL Server - Import wizard fails with incomprehensible message

29. June 2015 Anton Urbaník Database (0)

Many times the confused/unknown error has a simple resolution. I tried to import big .csv file with simple GEO information to database. The columns were “IP Address“, “Country Code”, “Region”, “City”. When I open the file all columns look simple with length less then 50 characters. And that was the problem. I tried to import this file by following wizard:

MsSQL Server - Import Data Wizard

And when you specifying the source, look at the “Advanced” section and increase the length of your columns (string columns)

MsSQL Server - Import Data Wizard - Csv file as Source

MsSQL Server - Import Data Wizard - Csv file as Source

Otherwise, when the length of your columns will be short you see en error similar as on this screen (but this is error about wrong encoding Smiech):

MsSQL Server - Import Data Wizard - Error view

Text version of error:

Validating (Error)
Messages
Error 0xc02020f4: Data Flow Task 1: The column "IPFrom" cannot be processed because more than one code page (65001 and 1250) are specified for it.
 (SQL Server Import and Export Wizard)
 
Error 0xc02020f4: Data Flow Task 1: The column "IPTo" cannot be processed because more than one code page (65001 and 1250) are specified for it.
 (SQL Server Import and Export Wizard)
 
Error 0xc02020f4: Data Flow Task 1: The column "Code" cannot be processed because more than one code page (65001 and 1250) are specified for it.
 (SQL Server Import and Export Wizard)
 
Error 0xc02020f4: Data Flow Task 1: The column "Region" cannot be processed because more than one code page (65001 and 1250) are specified for it.
 (SQL Server Import and Export Wizard)
 
Error 0xc02020f4: Data Flow Task 1: The column "City" cannot be processed because more than one code page (65001 and 1250) are specified for it.
 (SQL Server Import and Export Wizard)
 
Error 0xc004706b: Data Flow Task 1: "Destination - dbip-cityT" failed validation and returned validation status "VS_ISBROKEN".
 (SQL Server Import and Export Wizard)
 
Error 0xc004700c: Data Flow Task 1: One or more component failed validation.
 (SQL Server Import and Export Wizard)
 
Error 0xc0024107: Data Flow Task 1: There were errors during task validation.
 (SQL Server Import and Export Wizard)

And when I optimized the length … the interesting thing was, that problematic column was the most unlikely - the “Code”. Code which is in 99% with 2 characters Diabol