Hi,

I have a table on a SQL Server 2000 database with a single column of
type NCHAR(1). I have an Oracle 9i table which also has an NCHAR(1)
column.

I try to do a DTS Transform Data Task between the two and I receive the
following error:

"ORA-0141: inserted value too large for column"

I have tried extending the length of the target column still with no
joy. I also get the same error when the source column is CHAR(1).
Linked servers do not seem to work either as I get the error:

"OLE DB error trace [Non-interface error: Column 'TESTCOL'
(compile-time ordinal 1) of object '"MY_DATABASE"."TEST_NCHAR"' was
reported to have a DBTYPE of 129 at compile time and 130 at run time]."

The client owns the Oracle database and we are not able to change the
datatype of the target table.

Any clues??

Patrick.