Trying to access an Informix database that has UTF8 data stored in a en_us.819 database and I am having problems reading the data through SQL. It is not translating properly. We get proper translation of the lowercase french accents but the uppercase french accents are not being translated. The source database is a vendor supplied DB so I cannot get the vendor to change there side of things as they have indicated the data looks OK on the DB side. I'm on 64 bit, Windows Server 2008, running MS SQL 200. I have tried to connect with Informix OLEDB (64 bit) and also INformix (ODBC) . ODBC Connection String: uid=informix;Dsn=Test_DB; DB_Locale=en_us.819; Client_Locale=en_us.1252; (i have also tried en_us.CP1252, and en_us.UTF for client). Any help or examples from an SSIS perspective to have script components that specifically encode this type of data would be greatly appreciated. Charles