Hi i am getting following error message while executing a package that updates the column value using a derived column transformation.. -------------------------------------------------------------- [TRR_FE_Parse_File [271]] Error: The "component "TRR_FE_Parse_File" (271)" failed because truncation occurred, and the truncation row disposition on "output column "SrcFileName" (32263)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "TRR_FE_Parse_File" (271) failed with error code 0xC020902A. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. Error: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC020902A. There may be error messages posted before this with more information on why the thread has exited. [TRR_FE_File [16]] Error: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. Error: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread1" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled. ---------------------------------------------------------- I have checked the length of column in input & output..both are same .Any Help would appreciated.. Thanks in advance...

Did you check, what is writing into the Derived Column? There must be something longer than the destination. Put an Error-Output and write the Error-Row to a textfile.

do you get this error if you remove the Derived Column transformation? just want to check if the Derived Column is causing this issue.Shalin Kapadia