This issue can occur due to data types and code page issues
Make sure that code page is selected as UTF-8, if code page is UTF-8 and you still see this issue, edit the task and change the datatype to nvarchar and re-run the task this should fix the issue
Neeraj, one question out of curiosity (and because it's a huge issue for some PowerCenter customers): does ICS handle all Unicode characters or only those in the BMP (Basic Multilingual Plane, the first 64k characters defined in Unicode)?
PowerCenter still can't handle characters outside the BMP, and as far as I understand this matter ICS uses a specialised PowerCenter version underneath the cover. So I dare to assume that this drawback applies to ICS as well.
Is this the case?
Thanks and regards,