March 31, 2011 at 7:27 am
Hi, I have a excel file with some chinese texts in some fields. I have saved the excel file in unicode text format and have changed the font of the saved file to SimSun 18030. Now I can see the chinese characters in unicode txt file. I have to export this data to sql table. I am using SSIS. In source I have used flat file source. In the connection manager of the flat file source we have column tab where we can see the data from the file we have connected. Here I should see the chinese text but it is displaying some junk data.
To resolve this I have changed the Locale option in General tab in connectio manager of flat file source to all chinese option we have in drop down there. But still I am not getting chinese text. For chinese text fields I am using Unicode String (DT_WSTR) data type.
Kindly tell me what should I do to resolve this problem.
Also please tell me what should I do in SQL Server 2005 to see the chinese character.
Thanks
Rajneesh
April 1, 2011 at 3:44 am
Regarding the SQL Server part: you should use NVARCHAR there.
Regarding the SSIS part: it should work when you use DT_WSTR, as it is the unicode datatype from SSIS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply