Unanswered: Error while Importing text file using SQL Server DTS package
I am trying to import a sql server table having a text column to a similar MySQL table. I get the following error message -
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.
Even with export to text file and then import that text file to MySQL gives the same error.
I have also tried MySQL connection in DTS package with mysql-oledb-3.0.0 but it seems it has some problems as it swaps the database name and server name parameters each time I open for edit or test connections.