SQL Server Import and Export Wizard Error: 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

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: When the "Choose a Data Source" windows pops up, on the left-hand side, there columns and one of them says "Advanced". Click on the Advanced and when another window shows up, on the right hand-side there is a column called "Msc", change the DataType in the dropdown menu to "text stream [DT_TEXT].

Yes Was this page helpful? No
Yes Was this page helpful? No