I'm running a package in Debug (also tried in SSIS Catalog) and the package is completing successful, but it isn't running all executables.
I've tried checking and changing the Constraints from AND to OR, checked the "OnErrorFailPackage' equals True, run it several times with Breakpoints to validate the variables, and checked the SQL tables for changes (deletes). Everything seems fine.
I think I'm missing something very simple and obvious but would welcome some input.
Here's the package: