Rollback STG
For SSIS Only. Determines if the Batch orchestration engine rolls back (deletes) committed changes to the Staging database in case of a failed process.
When enabled, the generated batch package includes a rollback container that runs before reprocessing: for source-to-staging loads it truncates the Staging table, removing the rows committed by the failed run.
When to Change This Setting
Keep the default N when staging tables are truncated at the start of each load anyway. Enable it when a failed batch must leave the Staging database clean before the batch is restarted.
Related Settings
| Setting | Interaction |
|---|---|
| Rollback PSA | The equivalent rollback for the Persistent 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.