Try to make a database connection in Oracle via ODBC. It's much faster then
DTS. The other way Oracle to SQLserver then DTS is faster.
On the server you have to install the latest odbc-driver (in MDAC 2.8).
Now you can INSERT...SELECT...FROM..._at_xxx
<lsllcm_at_gmail.com> schreef in bericht
news:1104918022.165889.263950_at_z14g2000cwz.googlegroups.com...
> How to export unicode data from MSSQL 2000 to Oracle 9?
>
> The OS platform is Windows, Oracle is 9.0.1, The MSSQL is 2000. I use
> the northwind db of MSSQL as example. I use two methods. One is to use
> MSSQL DTS tool. The another is to save as csv file by using DTS, then
> use Oracle SQLLDR to load it. But we cannot export the unicode data
> successfully. The example data is Table "customers" Column
> "COMPANYNAME".
>
> Can anyone help?
>
> Thanks in advance!
>
Received on Thu Jan 06 2005 - 16:44:14 CST
