SSIS-将数据从Informix源加载到SQL Server源 [英] SSIS - load data from informix source to sql server source

问题描述

大家好，

(我正在使用SQL Server2005.)

我必须将数据从Informix数据源加载到Sql服务器数据源.我设法创建了连接管理器.使用IBM Informix创建作为oledb提供程序的源
写一个查询..查询成功..但是单击确定时出现错误.
警告信息:

Hi All,

(I am using SQL Server 2005.)

I have to load data from Informix data source to Sql server data source.I have managed to create connection manager. Create a source as oledb provider using IBM Informix
write a query.. Query was successfull.. but giving me an error while clicking on Ok.
Warning message:

Warning at {EE28B0F3-B7BC-4311-8E7D-F809EAD92902} [OLE DB Source [1]]: 
Cannot retrieve the column code page info from the OLE DB provider.  
If the component supports the "DefaultCodePage" property, the code page from that property will be used.  Change the value of the property if the current string code page values are incorrect.  If the component does not support the property, the code page from the component's locale ID will be used.

请在这方面帮助我.

谢谢.

Please assist me in this regard.

Thanks.

推荐答案

如果有帮助，请参阅此链接...

Hi,

See this link if could help...
Loading data from Informix 2000 into SQL 2005

Regards,

这篇关于SSIS-将数据从Informix源加载到SQL Server源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！