What I did so far:
1.Set Propagate to False
2.set MaximumErrorCount to high value on ForeachContainer
3. set FailPAckageONFailure to true on each task in workflow
4. set ForceExecutionResult to Success on DataFlow
5. set ForceExecutionResult to Success on Package
Yes, the execution is successful
But Inside the Data Flow Task,
the execution stopped reading xml in xml task, because an error occurs about output column in occupancy
"[XML Source 1] Error: The "component "XML Source" (1)" failed because error code 0x80131537 occurred, and the error row disposition on "output column "isNotHabitable" (138)" at "output "occupancy" (130)" specifies failure on error. An error occurred on the specified object of the specified component."
What I want is to continue inserting to access table from xml even there is an error in occupancy because Ill create an exception handler in Event Handler to insert this error to another table.
Thanks!!!
You need to double click on XML source component, Select error output and then Redirect row in the dropdown menu "Set this value to selected cells:". This will create an error output on your component, i.e. a red arrow, that you can redirect to the destination of your choice.
User contributions licensed under CC BY-SA 3.0