Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    17

    Question Unanswered: SSIS error data transformation to mysql

    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?
    Last edited by ambrozio; 08-19-11 at 10:24.

  2. #2
    Join Date
    Aug 2011
    Posts
    5
    What about Find/Replace? Instead of removing them, it may be better to change the " to `, which is used in MySQL.

  3. #3
    Join Date
    May 2006
    Posts
    17

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •