November 2, 2007 at 1:48 pm
We are Importing from iSeries AS400 to SQL server 2005 using DB2 OLE DB Datasource Provider and SQL 2005 Import and Export Wizard. The wizard executes and imports 49588 records then fails with the following error:
"Error 0xc020901c: Data Flow Task: There was an error with output column "JE103A" (161) 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."
Any ideas on how to fix this? We have looked at the data on the AS400 source table and do not see any problems. thanks!
November 2, 2007 at 2:52 pm
Hi There
Usually means that the column you are posting into is shorter than the data destined for it
November 2, 2007 at 3:05 pm
well, yes, you'd think...:-) but in this specific case, we have the SQL field defined as varchar with 25 size which is larger than the AS400 data size.
August 16, 2017 at 7:50 am
enlarge the size of each columns
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply