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
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
Devart Team
Posts: 2085
Joined: Wed 02 Nov 2011 09:44

Return to dotConnect for MySQL