SSIS Execute SQL Task Error with MySQL ODBC Connection

SSIS Execute SQL Task Error with MySQL ODBC Connection

Postby indyx » Fri 04 Aug 2017 12:40

I create "Execute SQL Task" with properties:
ResultSet: None
ConnectionType ODBC
Connection via devart odbc driver for mysql
SQLSourceType: Direct input
SQLStatement: delete from tempt

Connection work properly for ODBC Source and ODBC Destination component.
Table tempt realy exists. Query work in MySQLWorkbench.
Task have no parameter mapping and no result binding.

Package execute with error:

Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "delete from tempt" failed with the following error: "Error HRESULT E_FAIL has been returned from a call to a COM component.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

What is it?...
indyx
 
Posts: 1
Joined: Fri 04 Aug 2017 12:15

Re: SSIS Execute SQL Task Error with MySQL ODBC Connection

Postby ViktorV » Mon 07 Aug 2017 11:47

We investigated the issue according to the description. Unfortunately, we could not reproduce the error in our test environment. In our project we created "Execute SQL Task" with the parameters specified by you and successfully deleted data of several test tables. For further investigation please compose and send us the simplest SSIS project (or SSIS package *.dtsx) via form e-support: https://www.devart.com/company/contactform.html
ViktorV
Devart Team
 
Posts: 1871
Joined: Wed 30 Jul 2014 07:16


Return to ODBC Drivers