CODEWITHSUNDEEP
sql-serverssissql-server-2012
Avinash
Avinash

Reputation: 553

Inserting Russian characters in table when file is loaded from SSIS

I'm trying to insert some value that is having Russian characters from SSIS.

Say I have a MYDATA.TXT (comma separated) and data as below

REM,DES,ID
FR1,Головка,8
GY2,6-гр,9
MO0,Болт,2

1st row is column headers. I'm using this in Flat file. After executing the task, the value are different in my table something like Головка

After some research I found that i have to use N before the text and column should be NVARCHAR. But i'm not sure how to do this in SSIS. I have around 1.2 million records, should I prefix my column with N for all rows or is there any other way in SSIS?

Upvotes: 1

Views: 347

Answers (1)

Red Devil
Red Devil

Reputation: 2393

Try to change the code page to 65001 (UTF-8).

enter image description here

In Advanced tab change the Datatype of DES column to unicode string [DT_WSTR]

enter image description here

Output:

enter image description here

Upvotes: 1

Related Questions