incorrect syntax ssis

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
robin.tanner
Posts: 1
Joined: Sun 15 Sep 2013 19:19

incorrect syntax ssis

Post by robin.tanner » Sun 15 Sep 2013 19:29

I'm trying to insert data to MySQL using SSIS but I'm getting this error using devart's mysql connector. I'm only trying to insert one column to test. The column is an INT.

[ADO NET Destination [270]] Error: An exception has occurred during data insertion, the message returned from the provider is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"CRM_ID") VALUES (8455)' at line 1

Pinturiccio
Devart Team
Posts: 2141
Joined: Wed 02 Nov 2011 09:44

Re: incorrect syntax ssis

Post by Pinturiccio » Thu 19 Sep 2013 15:03

The standard ADONetDestination quotes names with double quotes. MySQL supports double quotes only in the ANSI_QUOTES mode. Please set the sql-mode server variable of your MySQL server to "ANSI_QUOTES".
For more information, please refer to http://dev.mysql.com/doc/refman/5.0/en/ ... -mode.html
http://dev.mysql.com/doc/refman/5.0/en/ ... nsi_quotes

Post Reply