I have a DTS package that pumps data from a SQL Server table into an Oracle
table. I'm using an OLE DB connection and the Oracle "Instant Client" 10.
Once in a while, some of the data includes accented characters (like é).
These appear correct in SQL Server, but are funky in Oracle. The é character
transfers across as ¿. Is this something I can correct in my DTS package
(like the OLE DB connection properties, or the properties of the data pump)
or is this something that is not correct in the destination table?