Sorry, I should have mentioned that the destination is a text field. Data type, though, doesn't explain the transfer not pulling all the requested...
I have created a DTS routine to transfer data from an Oracle 8i to SQLServer 2000 environment, using Oracle 9i's ODBC driver. Everything works fine...
Separate names with a comma.