Execute SQL Task in SSIS Fails

Execute SQL Task in SSIS Fails

Postby Doughnuts » Thu 14 Nov 2013 05:05

Hi all,

I have installed the Devart dotConnect MySQL Professional drivers v8.1.26 (trial edition) on a Windows 7 x64 workstation, and am working on an SSIS 2012 package. I am running into an issue that I can reproduce with a very simple package:

1. Create a new SSIS project
2. On the Control Flow, add an Execute SQL Task component
3. Set the component to use an ADO.Net connection to a local MySQL 5.6 x64 database using the dotConnect driver. ResultSet is set to None, SQLSourceType is Direct input.
4. In the SQLStatement field, I use the statement "TRUNCATE TABLE model_dim_stage;" (without the quotes).
5. Right click on the task and select Execute.

The task fails with the following error:

[Execute SQL Task] Error: Executing the query "TRUNCATE TABLE model_dim_stage;" failed with the following error: "Malformed communication packet.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

I also have the latest MySQL Connector/Net driver installed. If I change the connection of the task to that driver (but leave everything else untouched) it works. I want to use the dotConnect driver though as the Connector/Net driver has other issues. If I change the SQL statement to a SELECT instead of the TRUNCATE, I get the same situation - the dotConnect driver fails with the same error and the Connector/Net driver works.

Any ideas? Thanks in advance,
Matt
Doughnuts
 
Posts: 3
Joined: Thu 14 Nov 2013 04:44

Re: Execute SQL Task in SSIS Fails

Postby Pinturiccio » Fri 15 Nov 2013 15:08

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 2046
Joined: Wed 02 Nov 2011 09:44

Re: Execute SQL Task in SSIS Fails

Postby Doughnuts » Sun 17 Nov 2013 22:24

Awesome, thanks.
Doughnuts
 
Posts: 3
Joined: Thu 14 Nov 2013 04:44

Re: Execute SQL Task in SSIS Fails

Postby Pinturiccio » Mon 25 Nov 2013 14:14

We have fixed the bug with "Malformed communication packet." error when executing a prepared statement on MySQL 5.6.14. We will post here when the corresponding build of dotConnect for MySQL is available for download.
Pinturiccio
Devart Team
 
Posts: 2046
Joined: Wed 02 Nov 2011 09:44

Re: Execute SQL Task in SSIS Fails

Postby Pinturiccio » Thu 28 Nov 2013 13:08

The new build of dotConnect for MySQL 8.1.45 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=28407
Pinturiccio
Devart Team
 
Posts: 2046
Joined: Wed 02 Nov 2011 09:44

Re: Execute SQL Task in SSIS Fails

Postby Doughnuts » Tue 03 Dec 2013 03:01

Works perfectly now. Thanks for the fix :D
Doughnuts
 
Posts: 3
Joined: Thu 14 Nov 2013 04:44


Return to dotConnect for MySQL