dbTalk Databases Forums  

Warning - Cannot retrieve...

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Warning - Cannot retrieve... in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Georg
 
Posts: n/a

Default Warning - Cannot retrieve... - 12-10-2007 , 02:04 PM






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












Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.