I am trying to write an SSIS package to transfer data from SQL Server 2008 to MySQL.
I am trying to directly transfer the data between the tables...
The following is the error I am getting:
[ADO NET Destination ] 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 '"state_id", "state_name", "state_code", "state_system") VALUES (p1, p2, p3, p4);' at line 1
I am not using any query to transfer the data. But I get the above message. I don't understand how to fix this.
There is no issue when I transfer the data between SQL 2005 and MySQL.