1

I have an SSIS sequence container that extracts data from individual source database tables into a Stage layer. However, I need to know when a given calculation crashes in order for the given error to be written to the configuration table, which is provided by the yellow highlighted task in which the procedure is called. The problem is that if a given container falls due to an error, it does not flow through failure precendence constraint into the given task (LogPackageFailed).

I tried setting FaiPackageOnFailure together with FailParentOnFailure to TRUE in the properties, but it didn't help. The proposed solution in the following links does not work either:

, which was addressed in a previous similar query.

SSIS-fail

1
  • Can you post or doublecheck all of your expressions leading into the task? It's possible that it is not executing because of how they are configured, and not something on the package level.
    – BCM
    Apr 23, 2021 at 13:31

1 Answer 1

0

I would look at the event handlers (Package explorer tab shows this nicely). Something in there might be tamping down the failure or the DWH_STAGE container might have an explicit return status.

Something is off because a minimal reproduction works as expected

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.