CODEWITHSUNDEEP
sql-serverunicodeimportssis
Pirvu Georgian
Pirvu Georgian

Reputation: 691

Collation , convertion and importing from ssis with german chars

My table is in SQL and contains only nvarchar columns. The columns collation is set to Latin1_General_CI_AS . I want to import from SSIS, using flat file connection, some data that contains german charachters like Ö, Ü, etc. In the flat file connection manager i have set the Code page:65001 (UTF-8) and the locale Germany, like in the attachement below and in the preview i have the data accordingly (Ex: Nürnberg). However, when I execute the task and check the data in SQL table , it appears Nürnberg.

Am I missing something in this process?

enter image description here

Upvotes: 0

Views: 1409

Answers (1)

Jarle Bjørnbeth
Jarle Bjørnbeth

Reputation: 429

I am assuming that your file is not Unicode. Since you get the "cannot convert between unicode and non-unicode string data types." error when using the 1252 ANSI code page, and you can change the datatype of your columns. I would just convert them to varchar. Since varchar is not Unicode the error should stop occurring.

The alternative would might be to do some thing like this: Import Package Error - Cannot Convert between Unicode and Non Unicode String Data Type, but I think it would be easier to use varchar columns.

Upvotes: 1

Related Questions