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?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • 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