Derived column TRANSFORMATION Parsed Error
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...
November 19th, 2010 2:14am

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.
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2010 2:25am

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
November 19th, 2010 2:27am

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

Other recent topics Other recent topics