Data Conversion Failed

[rahulsony111]

I have a column whose datatype is DT_WSTR in source and DT_STR in target.
I tried to convert datatype in DATA CONVERSION but it failed.

I am getting error msg
"[Data Conversion [872]] Error: Data conversion failed while converting column "DXAEQI" (1802) to column "Copy of DXAEQI" (3099).
The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
"

I tried different ways but unable to find a solution for this.
Data conversion is working for some values of that column, but when the value in column is of russian language i am getting error.

I kept the TruncationRowDisposition as RD_IgonreFailure. Then it is working, but data is changing from russian language to someother like "??????????????".

Please help me out

 

[MDXer]

if you look at the data that is of the russian character set you will probably find some unicode characters Unicode which is DT_WSTR.