MySQL - Tranactions

MySQL - Tranactions

Postby tarasverq1 » Wed 13 Sep 2017 11:40

Hello!

How can I rollback or apply transaction to MySQL Destination?

My ControlFolw:

Image

DataFlow:
Image

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?
tarasverq1
 
Posts: 2
Joined: Fri 08 Sep 2017 15:11

Re: MySQL - Tranactions

Postby Pinturiccio » Mon 18 Sep 2017 14:53

SSIS Data Flow Components for MySQL do not support transactions.
Pinturiccio
Devart Team
 
Posts: 2024
Joined: Wed 02 Nov 2011 09:44


Return to SSIS Data Flow Components