I have a table from Oracle with some fields containing Chinese Characters. I created a DTS package in MSSQL 2000 server (English Win2000) with transformation of that table from Oracle to MSSQL. The chinese text field on the MSSQL side are ntext. If I run the package on my PC (Chinese Win2000), the import is ok. But if I run the package directly on the testing server (English Win2000), the chinese text imported to MSSQL became unknown characters. Please help. Urgent!
Note: I tried to change locale of the testing server to Chinese Traditional and also checked the box of supporting Chinese Traditional characters under Control Panel/Regional Setting. Doesn't work.