Force execution result SSIS is not working

Question

I have a file system task in an SSIS control flow. If it fails, it should not fail the package.

I can force a success on the task itself, and disableEventHander, but how can I get the whole package to return 0 (value of success)?

Here`s the answer that worked: http://stackoverflow.com/questions/6053501/ssis-package-property-forceexecutionresult-does-not-work-as-expected?rq=1 — dirtyw0lf, Oct 23 '12 at 15:09

score 1 · Answer 1 · answered Oct 22 '12 at 19:41

Set the FailParentOnFailure property of the file system task to False.
Set the MaximumErrorCount of the file system task to a number that is high enough to accommodate the number of "normal" errors you may receive while running the task.

(See the Microsoft post from 9/3/10)

score 1 · Answer 2 · answered Oct 23 '12 at 09:49

1

Double click on the sequence line and change value to completion.

answered Oct 23 '12 at 09:49

Farfarak

1,497
1
8
8

score 0 · Answer 3 · answered Oct 22 '12 at 18:54

You can set ForceExecutionValue to True on the package itself and set the ForceExecutionResult to Success if you want to ALWAYS return a success, or alternatively you can set the MaximumErrorCount higher than the number of errors you have if you want to return success only when a certain number of failures happens.

Force execution result SSIS is not working

3 Answers3