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