March 11, 2010 at 11:34 am
As i said in description 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
March 12, 2010 at 1:35 am
You are trying to convert a unicode string (DT_WSTR) to a non-unicode string (DT_STR).
If there are unicode characters that are not found in the code page of DT_STR (like the russian characters), you'll get an error, because he simply cannot convert them.
There are two options:
* make the target unicode
* deal with the loss of data for special characters
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply