Post reply

SSIS MySQL -> SQL Server

  • November 23, 2011 at 6:34 am

    #252337

    Hi everyone

    I have a data flow task that uses the ADO.Net Source object to connect to a remote mySQL database.

    I then have a data conversion task to convert the values and then a OLE DB destination to my local SQL Server 2008.

    I have setup the queries, connection, conversions etc.

    I get no errors what so ever, but the task isn't importing any rows into my SQL Server?

    If I run the query manually on the mySQL tables it returns 12 rows.

    Am I missing something?

    Thank you.

  • November 23, 2011 at 11:23 pm

    #1412558

    If I click on the preview button for the ADO.Net datasource it comes up empty, but I now the rows are there, even if I simplify the query, it still returns 0 records, but it doesn't give me any error.

    any ideas?

  • November 24, 2011 at 2:47 am

    #1412600

    I changed the connection type from connector/Net to connect/ODBC 5.1

    working 100% now 🙂

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

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