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?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply