You can choose to roll back a transaction at the next commit point if the Integration Service encounters a non-fatal error. When the Integration Service encounters a non-fatal error, it processes the error row and continues processing the transaction. If the transaction boundary is a commit row, the Integration Service rolls back the entire transaction and writes it to the reject file.
The following table describes row indicators in the reject file for rolled-back transactions:
Row Indicator
Description
4
Rolled-back insert
5
Rolled-back update
6
Rolled-back delete
The Integration Service does not roll back a transaction if it encounters an error before it processes any row through the Transaction Control transformation.
