MySQL - Tranactions

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
Posts: 2
Joined: Fri 08 Sep 2017 15:11

MySQL - Tranactions

Post by tarasverq1 » Wed 13 Sep 2017 11:40


How can I rollback or apply transaction to MySQL Destination?

My ControlFolw:



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?

Devart Team
Posts: 2105
Joined: Wed 02 Nov 2011 09:44

Re: MySQL - Tranactions

Post by Pinturiccio » Mon 18 Sep 2017 14:53

SSIS Data Flow Components for MySQL do not support transactions.

Post Reply