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

I am exporting the database from MSSQL to MySQL I get the error above,

Looking for a solution to this, can anyone assist,

I have tried a couple of things checking the "do not count column length" and "safe" and "large result" anyway anytime I run the query I get

OLE ODBC generic connector error
Query-based insertion or updating of BLOB values is not supported.

But the issue is it is always using the Generic OLE Connector instead of the Mysql specific driver.

Any assistance would be great

I feel as though I 've had a few drinks, I guess the 14 hours on this DTS is catching up.

THanks for any assistance

Jack - over and out and zzzzzzzzz