Hi,
I am running a DTS package on the local SQL Server DB to insert
data from an SQL Server table (remote DB) into an Oracle table (remote
DB). The Oracle and SQL Server DBs are on different machines. During
this process the special character (with a dash over 'e', ascii: 138)
is getting changed to 'h'. Both the fields are nvarchar(255). It led me
to think that the error is coming from the migration of special
characters from an Oracle DB to SQL Server DB.

Just to confirm my doubts, when I tried to insert the data into the
local SQL Server table from the remote SQL Server DB, the special
characters were inserted just fine, so I believe the above error is due
to different settings on the SQL Server and Oracle DBs, but I dont know
what exactly it is.

If you have come across such a situation or know the solution to this
problem, your help will be greatly appreciated.

Thanks,

Amber

Well, I just found out that those special characters are UNICODE
charcters and have ascii value (> 127). I dont know if that helps you
in finding the solution.

Thanks,

Amber