Post-read and post-load stored procedures are considered post-session stored procedures. Both run after the Integration Service commits all data to the database. If a database errors during a post-session stored procedure, the Integration Service performs a different action depending on the session configuration:
If you configure the session to stop upon stored procedure error, the Integration Service fails the session.
However, the Integration Service has already committed all data to session targets.
If you configure the session to continue upon stored procedure error, the Integration Service continues with the session.