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=e n_US.CP1252;DB_ LOCALE=en_US.81 9
OLE DB Source Custom Properties...
AlwaysUseDefaul tCodePage= 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.CP12 52)?
Thanks
Georg
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=e n_US.CP1252;DB_ LOCALE=en_US.81 9
OLE DB Source Custom Properties...
AlwaysUseDefaul tCodePage= 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.CP12 52)?
Thanks
Georg