I have been trying to convert some information in my MS SQL server database to MySQL using DTS, so that the information can be dumped to MySQL on an automated schedule.
I am having a problem with a few fields. Specifically text fields which contain over 8000 characters. When the DTS package runs, I receive an error indicating that the query based insertion of Blob fields is not supported. I have tried CASTing the field, but because some of the fields contain more then 8000 characters I still receive the error.
I can use Access to "pass" the data from MS SQL server to MySQL. I can also use SQLyog to suck data from MS SQL and push it to MySQL.
Why won't DTS work? Is there any way to make this work from MS SQL / DTS?