Mysql odbc is givinbg error

• habur2001

  Grasshopper

  Points: 13

  More actions

  May 20, 2008 at 8:30 pm

  #182683

  Hi,

  I hav e created SSIS package with mysql odbc connection

  I am trying to pull out 3 milion recs from mysql table into sql server table

  but I am getting " Mysql client ran out memory error"

  it works for less than million recs?

  any help?

  thanks,

  John

• Dave23

  Hall of Fame

  Points: 3903

  More actions

  May 21, 2008 at 2:17 pm

  #818860

  There's a post about this on the mysql forum that may help:

  http://forums.mysql.com/read.php?37,94800,190727#msg-190727