Post reply

SQL 2005 SSIS to MYSQL

  • July 15, 2005 at 1:01 am

    #165388

    Hi,

    I'm having problem trying to send data to a MYSQL Database from SQL 2005 using SSIS. I can get SSIS to Read data from MYSQL but I can't get to send the Data to Mysql.

    I would like to has anyone done this?

    Thanks

    Craig

  • July 17, 2005 at 11:51 am

    #575117

    I've never attempted this, but have heard that people are doing it without issue.

    Can you tell me what providerr you're using for the destination?

  • October 20, 2008 at 9:10 pm

    #887405

    I am also trying this. I am using the OLE DB provider from http://cherrycitysoftware.com/ccs/Providers/ProvMySQL.aspx

    I get a error similar to this, "Columns "Column 0" and "AccountNumber" cannot convert between unicode and non-unicode string data types".

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

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