I have flat text file containing millions of records. I am trying to import it into SQL server 2014 through Import Wizard.
According to the source of the file it is in UTF-8-character set hence in wizard I have selected the respective Code Page i.e. 65001 (UTF-8). But still I am continuously get following error.
Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "Title" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". (SQL Server Import and Export Wizard)
The file may contain some multicultural data e.g. Russia, German characters, so quite possible one of them are causing the problem. But given the huge size of file its manually not possible to fix them manualy.
Is there a way I can bypass this error and import the data, irrespective of the character set? Or is there a dynamic code page, that can encompass all characters.
User contributions licensed under CC BY-SA 3.0