MS SQL and MySQL Problem

Hi
I am trying to update a number of tables in a MySQL database from a MS SQL db using DTS. It gives an error due to the fact we are trying to update BLOB fields from MS SQL image fields.

Without the BLOB/Image fields it works fine with it gives the error.

Does anyone know of a work around or alternate solution - afaik it is a known problem.

Here is the offending section of the script for DTS

PASTE ===>
CREATE TABLE [dbo].[Ecommerce_products] (
[Company_ID] [varchar] (5) NULL ,
[Company_Name] [varchar] (40) NULL ,
[Stock_reference] [varchar] (20) NULL ,
[Stock_description] [varchar] (50) NULL ,
[Sell_Price] [float] NULL ,
[Sell_price_unit] [float] NULL ,
[Sell_price_description] [varchar] (40) NULL ,
[Available_Stock] [int] NULL ,
[Customer] [int] NULL ,
[Customer_Name] [varchar] (40) NULL ,
[Full_image_type] [varchar] (3) NULL ,
[full_image] [image] NULL
)
<=== END PASTE

 

 

 

 

Top