Hi,
I tried to transfer data from sqlserver2005 to oracle db.
For this, I have to convert some fields before.
I convert unicode data to nonunicode -
from DT_WSTR to DT_STR.
I began to do it with the wizard and the code page is 1252.
My problem is with the hebrew characters.
when there are hebrew characters in the field, it fails.
This is the error output:
"Text was truncated or one or more characters had no match in the target code page."
I tried to change the code page to 1255,
I changed "AlwaysUseDefaultCodePade" to True.
but I can't solve it.
Do you have any experience with it?
Thanks in advance.
Where did you change the code page to 1255? If it's in the Data Conversion transform and you still get the error, then the problem is likely that you have characters in your unicode string that can't be converted. In that case, you'll need to examine that string (try using the error output of the data conversion to get the string) and determine what characters are the cause and how you want to handle it (e.g. fix up or replace the string using another transform before inserting into Oracle). If you're not already using the Data Conversion transform, you could try reading the data in as DT_WSTR and then use the Data Conversion Transform to convert to 1255 to help narrow this problem down.
Another option to try is to do the string conversion outside of SSIS. For example, using a select statement with a cast in the source adapter that reads the data into IS already as DT_STR (the cast outside of IS may fail for the same reason which would also help you narrow this down).
|||Thank you very much!
I used Data Conversion transform, I changed all of the columns to code page 1255.
In the destination I also set the default code page to 1255, and it works.
