MySQL - Tranactions
Posted: Wed 13 Sep 2017 11:40
Hello!
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?
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?