Problem with migrating huge tables from MySQL database.

[archeykun]

Hi all,

I have to migrate the data from MySQL database to SQL Server using SSIS Wizard, also in this case I have used MySQL ODBC 3.51 Driver as a driver for migration. When I loaded the data about 10 millions rows, the migration completely works. But when I loaded the data about 18 millions rows, I got this message "Error loaded table_name [Source-table_name[1]]: An error occured executing the provided SQL command."

Here's the command I've used

 SELECT *
 
FROM table_name
 
WHERE Year(yy, a.time) = 2006 

I'm not sure whether the error caused by the driver or not.

If anybody knows how to solve this problem, please let me know

i would be very appreciated.

Thanks

[bxchen]

I used DFSTrans to migrate 18 millions rows, it works fine. here is the web site: www.DirectFocusSoftware.com