SQL server to MySQL

[ramsfield]

I have created a DTS package to dumpdata from my SQL server to my MySQL . Things work fine except when the tables have text fields(SQL Server) that are being converted to long varchar(MySQL).

The error message is:

...Query based insertion or updating of BLOB values is not supported

Is this a limitation of SQL server or MySQL.

Is there anyway to make this work as a DTS package.

 

[MDXer]

if your inserting the data into mySQL and the error appears to reflect a failed insert I would say it is a mySQL issue.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck