DTS import problem with text datatype from SQL Server to MySQL table

Can anybody tell how to import a table with the text column from SQL Server 2000 to MySQL 4.0.17?
I tried this using ODBC connection but got an error message saying, "Query-based Insertion or updating of BLOB values is not supported".

Even with export to text file and then import that text file to MySQL gives the similar error-
Error Source: Microsoft OLE DB provider for ODBC drivers
Error Description: The number of failing rows exceeds the maximum specified.Query-based Insertion or updating of BLOB values is not supported.

I understand this could be a ODBC problem of handling the text data but
When I use "MySQL.OLEDB Provider" instead of "MySQL ODBC 3.1 Driver" to make a connection with MySQL in DTS package and setup a Transform Data Task between SQL Server(source connection) and MySQL(destination connection) I see all the MySQL tables appended with "INFORMATION_SCHEMA." in the dropdown list of destination table names in Transform Data Task Properties whereas there is no user or database named INFORMATION_SCHEMA in MySQL database.

If you dump the data to flat file from MS SQL and use load data infile are you receiving these errors? It appears that you may have a column to insert value issue.

Did you ever figure out how to do it?
John