December 5, 2016 at 5:23 am
I set ForEachLoop ForceExecutionResult to Success. Some iteration of ForEachLoop gives error but it is running end of the loop. But on Sql Server Agent it is still runing but I writes error on job history.
Is it problem?
December 5, 2016 at 5:49 am
But on Sql Server Agent it is still runing but I writes error on job history.
You wrote an error to job history? What problem do you think this is?
December 5, 2016 at 5:58 am
When I look at the Agent Job Activity I see error.
But loop is finished succesfully why write error to job history and
It writes first error and first loop error.
December 5, 2016 at 6:25 am
It's difficult to diagnose without looking into what the package is doing. Is there an error handler configured on the component which is failing inside the FEL?
December 5, 2016 at 7:03 am
No there is not any event handler.
I m using Microsoft Data Provider for SAP It calls a RFC (Remote Function Call) from SAP and in some loop iterations RFC gives error but I don t care about this error.
Thats why I set ForEachLoop ForceExecutionResult value to success when I run SSIS package it finishes successfuly but in execution result i this RFC errors but package compeletes succesfully.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply