I have a package running in SQL 2016 using Project Deployment. One of the steps executes a stored procedure. All of the tasks have their error parameters left at default so any error should cause the package to fail because the maximum error count is 1.
In this particular instance the database user account used for the connection manager did not have Execute permission for the stored procedure so the Execution failed, but the SQL Agent Job reported success even though it is set to report failure if the agent job step fails.
I checked the Execution Report in the SSIS Catalog. The overall status shows as success, but when I go into the details in shows the failure.
Is this a bug in SSIS or am I missing something?