The SQL transformation commits data depending on if the of database connection is dynamic or static.
If the connection is a dynamic database connection the Integration Service issues a commit after executing the SQL for each input row.
If the connection is a static connection the Integration Service issues a commit after processing all the input rows. The transaction includes all the database rows to update. When using a static connection, if the session fails due to some error in another transformation after the SQL transformation the Integration Service will issue a commit and there will be no option to rollback the changes.A feature request (CR 175658) has been created to provide the option to rollback the changes if session fails.
What can we do to improve this information (2000 or fewer characters)