Thursday, March 29, 2012

DB2 to SQL Server 2005 Problem

I am trying to copy some tables from DB2 to SQL Server 2005. DB2 database is on IBM iSeries server (AS400). Code page of all tables on AS400 is IBM-037. My Windows code page is 1250. Provider for data source is -IBM DB2 UDB for iSeries IBMDA400 OleDb provider-.

I get a following warning:

Setting Source Connection (Warning)
Messages
* Warning 0x80202066: Source - ACCMST [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.
(SQL Server Import and Export Wizard)

and data can not be copied.

I tryed to set source code page for source destination to 37, but it does't work.

Please help.

I am getting the same problem , a temporary workaround for me was to edit the SSIS transform and select float for packed decimal fields and integer for the other fields that could not have a data type assigned. once i did that the data copied. But this is an obvious problem for IBM to work on... I will pester our iSeries system admins to keep up and see if an IBM APAR ( program fix ) is released and post that info here.

No comments:

Post a Comment