error while importing data from db2 to sql server
you can configure error output and redirect error output from OLE DB Source to another destination and then run the package to see what values you will get in the error output, then you can troubleshoot the problemhttp://www.rad.pasfu.com
August 29th, 2012 8:38pm

Refer page number 7 on this link which compares the data types when migrating from DB2 to SQL. Make sure that the data types are crossing over well in terms of precision, scale instead of just going by the data type names. If you are still facing a issue, follow rezas recommendation to re-direct the errorneous row and then find the offending column data.http://btsbee.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
September 1st, 2012 5:36am

[OLE DB Source [2208]] Error: There was an error with output column "column name" (52) on output "OLE DB Source Output" (2). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". i was getting this error when i was importing data from db2 to sql server i checked all the datatypes and sizes in the both database are same then i cant figure out the error can anyone help me with this..
September 1st, 2012 7:24pm

it worked thanks
Free Windows Admin Tool Kit Click here and download it now
September 1st, 2012 8:18pm

you can configure error output and redirect error output from OLE DB Source to another destination and then run the package to see what values you will get in the error output, then you can troubleshoot the problemhttp://www.rad.pasfu.com
September 1st, 2012 8:25pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics