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
incorrect syntax ssis
-
Pinturiccio
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: incorrect syntax ssis
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
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