Issue with DbaseIV to SQL data pull (Unicode Problem Related To Swedish/English characters)
I have this odd problem with an SSIS migration Im doing. Im working with DBASEIV tables created in a Swedish ERP system. They use the Swedish ÅÖÄ characters in various fields. Im pulling this data into a SQL database. The characters appearing in the queries have odd greek characters in place of the swedish character when the data is pulled. Im using Unicode String[DT_WSTR] For the source datatype and the LocalID language is set to Swedish. The field datatypes are coming across a Nvarchar(XX) for the source database field size. I don't really understand why Im not getting the correct character's across. Any help would be greatly appriciated.
November 12th, 2010 9:14am

Set code page to 1252 in your target.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2010 9:40am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics