Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Import Data from DB2 [AS/400 EBCDIC]

Author  Topic  KTGR24 Starting Member 1 Post Posted - 2008-05-27 : 12:24:28 I am trying to import data from a db2 table [AS/400 - code page 875 IBM EBCDIC - Modern Greek] to SQL Server 2005. The collation selected in the sql server is GREEK_CI_AS. The import process begins but at a specific point i am receiving the following error messages and it stops: 1)""Warning 0x80202066: Data Flow Task: 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" AND another specific error message for the data in the column / field of the table "xxxxxx" where the problem resides(the initial data type of the field in DB2 is char(8) and i have used all options in sql server (e.g. nchar, nvarchar, varchar) with no success.... 2)* Error 0xc020901c: Data Flow Task: There was an error with output column "xxxxxx"(68) on output "OLE DB Source Output" (11). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". The Data Source that I am using is IBMDB2UDB for i-series IBMDASQL OLE DB Provider. Can anyone suggest any idea? Thanks in advance.