SSIS Error Derived Column Failed because Truncation Occurred

SSIS Error Derived Column Failed because Truncation Occurred

Error Message:

SSIS Error Derived Column Failed because Truncation Occurred: This is an error occurred while executing a SSIS package. The exact error message is “component “Derived Column” (20)” failed because truncation occurred, and the truncation row disposition on “output column “FilePath” (29)” specifies failure on truncation. A truncation error occurred on the specified object of the specified component.

SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component “Derived Column” (20) failed with error code 0xC020902A while processing input “Derived Column Input” (21). The identified component returned an error from the Process Input 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.

I have included few derived columns which are used defined variables and when I was trying to store these values into database package was failed at Derived_Column task.

It has been trying to capture the value of a variable “failepath” as shown in below figure

I understand that the column “filename” is unable to hold the actual file name capturing at runtime.  The error has been resolved after the output column size increased.


I have increased it to 60 and now the package ran successfully. 

Posted in MSBI, SSIS | Tagged , , , | 4 Comments

Leave a Reply

4 Comments on "SSIS Error Derived Column Failed because Truncation Occurred"

Notify of
avatar
Sort by:   newest | oldest | most voted
Václav Švaňa
Guest

Hello,

You’ve saved my day ! I had the same problem with derived column trasformation.

Thank you

Uday Arumilli
Guest

Thanks Švaňa

Pushpita Sar
Guest

Hello,

Thank you so much for this tip. It just made my day, had been struggling since yesterday on this.

wpDiscuz