How can I rollback or apply transaction to MySQL Destination?
My ControlFolw:
DataFlow:
I need to revert all actions if something in "Move Data" container went wrong.
Else I need to commit changes.
This scheme doesn't work. All data to MySQL moves without transaction.
How I can realize this logic using Devart MySQL SSIS components?