Rollback from inserting data in mother/daughter tables
About this task
Based on Inserting data in mother/daughter tables, insert a rollback function in order to prevent unwanted commit.
Procedure
- Drag and drop tMysqlRollback to the design workspace. tMysqlRollback ensures that the transaction will not be partly committed.
- 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.