incorrect syntax ssis

incorrect syntax ssis

Postby 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
robin.tanner
 
Posts: 1
Joined: Sun 15 Sep 2013 19:19

Re: incorrect syntax ssis

Postby 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/server-sql-mode.html
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_ansi_quotes
Pinturiccio
Devart Team
 
Posts: 1895
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for MySQL