SQL Server Performance

Can anyone Help me?

Discussion in 'SQL Server DTS-Related Questions' started by phpdeve, Nov 21, 2005.

  1. phpdeve New Member

    Hi All,
    When i was trying to Export Data From MS-Sql to MySql Using DTS, i get very strange error like,
    "Query based insertion or updating of BLOB values is not Supported"
    I have senn so many peoples are struggling with this problem. So kindly help us. Please...
    Can anyone help in this regards?

    Thanks
    phpdeve, Nov 21, 2005
    #2

  2. Argyle New Member

    Do you have the latest sql service pack and mdac versions?
    Do you have a unique index on the mysql destination table?
    Argyle, Nov 21, 2005
    #2

  3. Madhivanan Moderator

    Does MySQL support BLOB type?

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Nov 21, 2005
    #2

  4. FrankKalis Moderator

    FrankKalis, Nov 21, 2005
    #2

  5. phpdeve New Member

    hi
    i dont have created mysql tables manually and so it is not indexed. Mysql will definitly support BLOB. So what would be the problem?
    phpdeve, Nov 21, 2005
    #2

  6. FrankKalis Moderator

    FrankKalis, Nov 21, 2005
    #2

  7. Argyle New Member

    Put a unique index on the mysql table and see if it helps. Can be something how the cursor is built up and then a unique row identifier can help.
    Argyle, Nov 21, 2005
    #2

Share This Page