08 October 2013

Importing Chinese characters from CSV file to SQL server

Problem:

Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "Column 0" 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)

Solution:

1 comment:

Note: Only a member of this blog may post a comment.