SSIS Error Derived Column Failed because Truncation Occurred
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.