error data transformation to mysql

• Ambrozio

  Grasshopper

  Points: 20

  More actions

  August 19, 2011 at 7:45 am

  #246605

  Hi everybody,

  I am using BIDS 2008 to transfer data from sql server 2005 to mysql 5 and I am using objects Data Flow: "OLE DB Source " + "ADO.NET Destination".

  The insert command created by "BIDS 2008" to send data to mysql return error because use quotes in the specifications of the columns.

  see example:

  insert table1 ("col1","col2") values ...

  How do I remove the quotes?

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  August 19, 2011 at 11:37 am

  #1370921

  I would try using an Execute SQL Task instead of a dataflow

• Ambrozio

  Grasshopper

  Points: 20

  More actions

  August 22, 2011 at 12:05 pm

  #1371622

  the solution is in the link:

  http://blogs.msdn.com/b/mattm/archive/2009/01/07/writing-to-a-mysql-database-from-ssis.aspx?wa=wsignin1.0