ssis package execution error

  • while priew(MySQL) the table......

    i get this error plz help me...

    TITLE: Microsoft Visual Studio

    ------------------------------

    There was an error displaying the preview.

    ------------------------------

    ADDITIONAL INFORMATION:

    ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.27-community-nt]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 '"destination"' at line 1 (myodbc5.dll)

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

    SYSTEM CONFIG:

    WINDOWS XP SP3

    SQL SERVER 2008 Enterprise Edition

    Visual Studio 2008

    MySQL5.0

    mysql-connector-odbc-5.1.8-win32

    [font="Verdana"]SRIHARI(:~[/font]

  • Apparently there is a syntax error in your SQL query. Can you run the query on MySQL directly?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply