I have placed the Store Procedure in the tMSSqlSP component.
Data truncation error appear in talend job but no error when store procedure is executed manually.
Starting job Job_Clarity_Resource_by_Practice_000_Staging_To_Cdl at 19:13 13/12/2017.
[statistics] connecting to socket on port 3474 [statistics] connected Data truncation [ERROR]: imss.job_clarity_resource_by_practice_000_staging_to_cdl_0_1.Job_Clarity_Resource_by_Practice_000_Staging_To_Cdl - talendStats_DB - Data truncation Data truncation [ERROR]: imss.job_clarity_resource_by_practice_000_staging_to_cdl_0_1.Job_Clarity_Resource_by_Practice_000_Staging_To_Cdl - talendStats_DB - Data truncation [statistics] disconnected Job Job_Clarity_Resource_by_Practice_000_Staging_To_Cdl ended at 19:13 13/12/2017. [exit code=0]