Enable Rollback
For SSIS only. Determines if the Batch orchestration engine rolls back (deletes) committed changes to the Data Vault database in case of a failed process.
When enabled, the generated SSIS packages add rollback tasks that run when a previous execution did not complete: rows written to Data Vault targets with an audit id later than the last successful execution are deleted, and for Satellites and Link Satellites the effective-to dates and current-row flags are additionally reset so the rerun starts from a consistent state.
When to Change This Setting
Keep the default N when loads are idempotent or recovery is handled operationally. Enable it when a failed batch must be automatically cleaned up before the next run, so partial loads never remain in the Data Vault.
Related Settings
| Setting | Interaction |
|---|---|
| Enable Rollback PSA | The equivalent rollback control for the Persistent Staging Area |
| Enable Rollback STG | The equivalent rollback control for the Staging layer |
| Use Transactions | Database-transaction wrapping of individual ELT loads, as opposed to orchestration-level rollback |
Notes
- This setting is part of the Data Vault settings category.
- The default value for this setting is
N.