[Flat File Source [1]] Error: Data conversion failed.
The data conversion for column "Column 22" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.."
Reason:
When I digged out the reason while Importing from csv file to SQL Databse. I found there was some data issue (nvarchar). So when you try to import your data from CSV to SQL,
you have to check proper data type and length of data as well.
Simply change the datatype by going to flat file connection manage advanced tab and its length to unicode.
It Works.
The data conversion for column "Column 22" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.."
Reason:
When I digged out the reason while Importing from csv file to SQL Databse. I found there was some data issue (nvarchar). So when you try to import your data from CSV to SQL,
you have to check proper data type and length of data as well.
Simply change the datatype by going to flat file connection manage advanced tab and its length to unicode.
It Works.
Comments