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
  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?
  3. Madhivanan Moderator

    Does MySQL support BLOB type?

    Madhivanan

    Failing to plan is Planning to fail
  4. FrankKalis Moderator

  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?
  6. FrankKalis Moderator

  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.

Share This Page