Hi All, I hope someone will be able to help me figure out this one as am struggling since quite a bit of time :( I am using SSIS to import Data from Oracle into SQL. I am using the Oracle provider for OLEDB in an OLEDB source component to execute my Orcale query and importing into a freshly generated SQL table The execution of the package fails and the errors am getting in the execution results are: [OLE DB Source [2208]] Error: There was an error with output column "SUM(AL5.QUANTITY)" (2439) on output "OLE DB Source Output" (2218). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". [OLE DB Source [2208]] Error: The "output column "SUM(AL5.QUANTITY)" (2439)" failed because truncation occurred, and the truncation row disposition on "output column "SUM(AL5.QUANTITY)" (2439)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. the destination column SUM(AL5.QUANTITY) is set to nvarchar(max) any idea? Many thanks for your help hugely appreciated

Please check the datalength between source and destination. But, why do you store sum of quantity in a varchar?

Is it destination table column does it have same datatype of source table column in terms of size and lengthhttp://uk.linkedin.com/in/ramjaddu

you can right click on the source, select advanced editor, and go to input & output columns, and under output columns find your column and check length of that column and change it there. But my question is also : why you want to store results in a nvarchar field?!http://www.rad.pasfu.com My Submitted sessions at sqlbits.com