SQL 2005 SSIS to MYSQL

• Craig Stonehouse

  SSChasing Mays

  Points: 602

  More actions

  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

• Kirk Haselden

  SSCommitted

  Points: 1683

  More actions

  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?

• elrond

  SSC Enthusiast

  Points: 154

  More actions

  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".