Connecting to MYSQL

  • Please assist. I am having trouble connecting to MYSQL via SSIS. I would like to use MYSQL as a source and destination. I am trying to move data from SQLSERVER to MYSQL. I have downloaded the latest MYSQL driver, still no use.

     

    mysql

  • What is the problem? Can you be more specific?

    If you aren't happy single, you won't be happy in a relationship.

    Remember, happiness comes from guitars, not relationships.

  • Getting errors when using the odbc string connection:

     

    odbc

     

    When i use the MYSQL connector, i am getting this messages below. I do create the table with mysql code.

    mysql2

    I get this error:

    TITLE: Microsoft Visual Studio

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

    The table name could not be retrieved from the script provided. Select a table or a view from the list.

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

    BUTTONS:

    OK

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

     

    I can also not view or load tables that already exist.

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

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