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

Make sure that the column length is same or more than the length of the output records. If the column length is less than the length of the output records then this kind of error will occur.Regards, Sandesh Segu http://www.SansSQL.com ↑ Grab this Headline Animator

Please provide more information: The expression you're using in the Derived Column component. Whether the Derived Column component is adding the result of that expression as a new column, or replacing an existing column. What the metadata (data type and size) of the column being created or updated in the Derived Column is. The metadata (data types and sizes) of the columns listed in the above expression. Talk to me now on

Please provide more information: The expression you're using in the Derived Column component. Whether the Derived Column component is adding the result of that expression as a new column, or replacing an existing column. What the metadata (data type and size) of the column being created or updated in the Derived Column is. The metadata (data types and sizes) of the columns listed in the above expression. Talk to me now on