Search found 1 match

by indyx
Fri 04 Aug 2017 12:40
Forum: ODBC Drivers
Topic: SSIS Execute SQL Task Error with MySQL ODBC Connection
Replies: 8
Views: 30775

SSIS Execute SQL Task Error with MySQL ODBC Connection

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?...