The Integration Service rolls back transactions in the following circumstances:
Rollback evaluation.
The transaction control expression returns a rollback value.
Open transaction.
You choose to roll back at the end of file.
Roll back on error.
You choose to roll back commit transactions if the Integration Service encounters a non-fatal error.
Roll back on failed commit.
If any target connection group in a transaction control unit fails to commit, the Integration Service rolls back all uncommitted data to the last successful commit point.