question

sandeepa avatar image
sandeepa 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.
sql-server-2005ssisinformix
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Usman Butt avatar image
Usman Butt answered
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.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Daniel Ross avatar image Daniel Ross commented ·
+1, this also happens when you connect to Oracle.
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.