If the Integration Service identifies a target in the target load order group that does not receive commits from an active source that generates commits, it reverts to target-based commit for that target only.
The Integration Service writes the name of the transformation used for source-based commit intervals into the session log. When the Integration Service switches to target-based commit, it writes a message in the session log.
A target might not receive commits from a commit source in the following circumstances:
The target receives data from the XML Source Qualifier transformation, and you connect multiple output groups from an XML Source Qualifier transformation to downstream transformations.
An XML Source Qualifier transformation does not generate commits when you connect multiple output groups downstream.
The target receives data from an active source with multiple output groups other than an XML Source Qualifier transformation.
For example, the target receives data from a Custom transformation that you do not configure to generate transactions. Multiple output group active sources neither generate nor propagate commits.