Thanks for replies to SQLBuddy and Sanjay.

I followed steps by Sanjay and it worked perfectly as mentioned. I can now see chinese and Korean data in columns.

Thanks again.

Any one here ?

I will rephrase my question again.

I want to move data from Oracle using DTS package to SQL Server.

Two column has chinese / korean data and after data...

sqlbuddy123 (9/23/2010)

---

For converting into the unicode, you can use a data conversion transformation between the OLEDB Source and OLEDB destination and the in that data conversion transformation change the destination...

The code I tested for unicode insert in SQL Server is

create table yourtable (yourid int,yourvalue nvarchar(200))

go

insert into yourtable (yourid, yourvalue) values (1,'user1')

insert into yourtable (yourid,yourvalue) values (2,'user2')

insert into yourtable (yourid,yourvalue)...

Thanks Jeff. That's what I needed.