We want to use DTS to import data from a Japanese AS400 to our SQL Server
7.0 system.

The Japanese AS400 has some fields with mixed single and double byte
characters. Each double byte character string is wrapped in delimiter
characters. On the iSeries system, the data are stored as CCSID 65535. The
ODBC driver can force this into ASCII or another code page, but no matter
which one we've chosen, it doesn't seem to handle IBM's EBCDIC mixed byte
format correctly.

We are using the iSeries ODBC driver supplied by IBM.

--
Thanks,
Dallas