Based on Scenario 1: Inserting data in mother/daughter tables, insert a rollback function in order to prevent unwanted commit.
Drag and drop tMysqlRollback to the design workspace.
Connect tFileList to tMysqlRollback with an OnSubjobError trigger.
Double-click tMysqlRollback to enter its Basic settings view.
From the Component List, select the connection component.
tMysqlRollback ensures that the transaction will not be partly committed.