Rollback PSA
For SSIS Only. Determines if the Batch orchestration engine rolls back (deletes) committed changes to the Persistent Staging database in case of a failed process.
When enabled, the generated batch package includes a rollback step that deletes from the PSA table the rows whose audit id is higher than the last successful execution, removing what the failed run committed before the batch is reprocessed.
When to Change This Setting
Keep the default N for the standard restartable behavior. Enable it when a failed batch must not leave partially committed data in the PSA — for example when partial data would disturb downstream delta comparisons.
Related Settings
| Setting | Interaction |
|---|---|
| Rollback STG | The equivalent rollback for the Staging database |
| Rollback DV | The equivalent rollback for the Data Vault database |
Notes
- This setting is part of the Staging Persistent settings category.
- The default value for this setting is
N.