asked
Loading data from one data source to another using SSIS Package
Hi All, (I am using SQL Server 2005.) I need to extract and load data from Informix data source to Sql Server Data source. I have managed to create connection manager. What I have done is created a source as oledb provider using IBM-Informix driver and use a query. The query is fine but it is giving me an warning: "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.
It is just a warning and you can ignore it, if you are sure that the values assigned by default are correct. This warning is due to the fact that default code page file (in XML format ) for IBM-Informix, which should be available in `"C:\Program Files\Microsoft SQL Server\90\DTS\MappingFiles"` is not there. But if you still need to get rid of this warning then Right click your OLE DB Source and enable the property "AlwaysuseDefaultcodepage" to true. HTH.
