We are receiving a flat file from SAP it is | seperated and I have opened the file at record 4145 where it says the error occurs. What I find is that the column is not greater than 50 however, there appears to be Unicode in this file. I can't be certain if this is the problem and I was hoping someone else had the same problem or has seen something simalar to this. Does anyone have an idea as to how to solve this issue. I also have tried to increase the column to 255 and I still get the same result. [s_Z0WBS_O06 CSV [1]] Error: Data conversion failed. The data conversion for column "Column 37" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". [s_Z0WBS_O06 CSV [1]] Error: The "output column "Column 37" (1381)" failed because truncation occurred, and the truncation row disposition on "output column "Column 37" (1381)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. [s_Z0WBS_O06 CSV [1]] Error: An error occurred while processing file "\\Path\file.CSV" on data row 4145. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "file CSV" (1) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.Antonio

How do you know the error occurs at record 4145? Have you redirected errors from the Source component? Talk to me now on

[s_Z0WBS_O06 CSV [1]] Error: An error occurred while processing file "\\Path\file.CSV" on data row 4145. This was an error line so I assume that it occured at 4145.Antonio

Try redirecting errors from the source component. I'm assuming s_Z0WBS_O06 CSV is the name of your source? Talk to me now on

Yes, it is I will try to redirect from my source thank you for the info I just kept bringing up a blank. I'll let you know how it turned out.Antonio