Target-Based Commit
The commit interval setting determines the point at which the Integration Service commits data to the targets.
Each time the Integration Service commits, performance slows. Therefore, the smaller the commit interval, the
more often the Integration Service writes to the target database, and the slower the overall performance.
Target-Based Commit ,If you increase the commit interval, the number of times the Integration Service commits decreases and performance improves.
When you increase the commit interval, consider the log file limits in the target database. If the commit interval is too high, the Integration Service may fill the database log file and cause the session to fail.
Therefore, weigh the benefit of increasing the commit interval against the additional time you would spend
recovering a failed session.
Click the General Options settings in the session properties to review and adjust the commit interval as below
The commit interval setting determines the point at which the Integration Service commits data to the targets.
Each time the Integration Service commits, performance slows. Therefore, the smaller the commit interval, the
more often the Integration Service writes to the target database, and the slower the overall performance.
Target-Based Commit ,If you increase the commit interval, the number of times the Integration Service commits decreases and performance improves.
When you increase the commit interval, consider the log file limits in the target database. If the commit interval is too high, the Integration Service may fill the database log file and cause the session to fail.
Therefore, weigh the benefit of increasing the commit interval against the additional time you would spend
recovering a failed session.
Click the General Options settings in the session properties to review and adjust the commit interval as below
What is source based commit
The Integration Service commits data based on the number of source rows. The commit point is the commit interval we can configure in the session properties.