locked
Inserting data from SQL server to MYSQL RRS feed

  • Question

  • Hello Friends

    I need to INPUT some values from SQL SERVER to MYSQL using SSIS.

    I have follow these

    http://blogs.msdn.com/b/mattm/archive/2009/01/07/writing-to-a-mysql-database-from-ssis.aspx

    but getting error;

    [ADO NET Destination [43]] Error: An exception has occurred during data insertion, the message returned from the provider is: ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.57-log]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 '"phone_number", "filter_phone_group_id") VALUES ('755514', 'EXISTING')' at line 1

    [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "ADO NET Destination" (43) failed with error code 0xC020844B while processing input "ADO NET Destination Input" (46). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.

    Please help 

    Saturday, March 16, 2013 7:21 AM

Answers

  • I got the same problem. It got resolved by running the following script in MySQL.

    Set global sql_mode=ansi_quotes;

    • Marked as answer by Eileen Zhao Friday, March 22, 2013 6:29 AM
    Sunday, March 17, 2013 11:12 AM

All replies

  • issue resolve.
    Saturday, March 16, 2013 10:44 AM
  • issue resolve.
    Can you please tell how you resolved? It might help some one else.

    Nitesh Rai- Please mark the post as answered if it answers your question

    Saturday, March 16, 2013 11:14 AM
  • I got the same problem. It got resolved by running the following script in MySQL.

    Set global sql_mode=ansi_quotes;

    • Marked as answer by Eileen Zhao Friday, March 22, 2013 6:29 AM
    Sunday, March 17, 2013 11:12 AM
  • Thank you so much this worked for me 
    Wednesday, May 27, 2020 6:42 PM