Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  DTS Import data from Oracle to SQL2000

Author  Topic  man_25 Starting Member 4 Posts Posted - 2006-09-08 : 05:11:36 I wish to transfer data from an Oracle DB that has Korean characters to an SQL Server 2000 DB which has collation = Korean_Wansung_CI_AS I use a DTS package for this. I did a test run and had the following prob - I did a test and tried transferring to my local PC to see how it would go. My SQL Server 2000 had collation = SQL_Latin1_General_CP1_CI_AS and the data shows up fine - I then did a dry run on the actual destination server (which is the SQL Server 2000 with collation = Korean_Wansung_CI_AS) the data is corrupted as you can see - From looking online for answers, particularly this link - http://support.microsoft.com/default.aspx?scid=kb;en-us;325335, I understand that you need to set the Use Collation property. But where do you set this? Even if I do set this, I am not sure if it will work. Is there any other way to transfer data (containing Korean characters) to my destination server without causing character corruption? ANY HELP/HINTS WOULD BE MOST APPRECIATED!!