Invalid column name when fetching large amounts of data

• Tibor_Sebok

  SSC Rookie

  Points: 32

  More actions

  July 2, 2022 at 6:12 am

  #4057823

  Hi Guys,

  I am developing an SSIS package right now where I have to pull large amounts of data (~45 million rows) from a MySQL DB.

  DB: MySQL 8.0.11

  Driver: MySQL 8.0 ODBC Unicode Driver (32-bit)

  It works pretty well when querying only a small amount of data (let's say 2 million rows), but when I try to fetch all rows, it sends an 'Invalid column name' error ('HY000'. Code: 517).

  Has anyone encountered this problem before?

  On ODBC side,

  - allow big results set

  - enable automatic reconnect

  - allow multiple statements

  are checked.

  Any feedback/help appreciated!

  Thanks,

  Br

  Tibor

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  July 3, 2022 at 7:10 am

  #4058079

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Jo Pattyn

  SSC-Dedicated

  Points: 32432

  More actions

  July 6, 2022 at 9:50 am

  #4059510

  No experience. Would start with updating odbc drivers. 8.0.29 seems to be the most recent version . https://dev.mysql.com/downloads/connector/odbc/