Warning - Cannot retrieve...

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Georg

    Warning - Cannot retrieve...

    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











Working...