DSXchange

Hi All,

I Have a job which loads sqlserver to oracle table iam getting a warning as

"Invalid character(s) ([xC9]) found converting string (code point(s): CAF[xC9]) from codepage UTF-8 to Unicode, substituting"

Can anyone hwlp me out what exactly this warning meant by. Thanks!

Thanks

Basically, it means there was a character that it could not convert and the hexidecimal value of that character was "C9", hence the "[xC9]" in the message. Hex C9 is Decimal 201 if you want to go look that up in your source/target charactersets.

I source charcterset is Project default (UTF-8)
Target characterset is Project default (UTF-8)

Do i need to change anything in there?

All,

In target oracle stage under extended i have removed unicode and now its fine .