Warning - Cannot retrieve ... ???

Posted in 2007

Georg — Mon, 10 Dec 2007 21:00:01 +0100 — source: Usenet: comp.databases.informix

Hello, I'm using SSIS (SQL Server Integration Services) via Native Informix OLE DB provider to extract (ETL) data from Informix 7.3 to SQL Server 2005. I have following problem, when I try to connect to the Informix database I'm getting : Warning - Cannot retrieve the column code page info from the OLE DB provider ??? Informix... Nls information for a database -------------------------------- Nls Capabilites and Attributes en_US.819 Collating Sequence en_US.819 CType SSIS... Native Informix OLE DB driver -------------------------------- CLIENT_LOCALE=en_US.CP1252;DB_LOCALE=en_US.819 OLE DB Source Custom Properties... AlwaysUseDefaultCodePage= False Any idea why I'm getting this Warning ? And, at the end, code page conversion en_US.819 < > en_US.CP1252 doesn't work? Any idea how to put(convert) Slavic characters like "'Ʈ'''澹'" from Informix(en_US.819) in to SQL Server 2005(en_US.CP1252)? Thanks Georg