MySQL Forums
Forum List  »  Connector/ODBC

SSIS - fetch data from MySQL 8.0.11 with MySQL 8.0 ODBC Unicode Driver (32-bit)
Posted by: Sebők Tibor
Date: July 01, 2022 11:58PM

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.

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

Options: ReplyQuote


Subject
Written By
Posted
SSIS - fetch data from MySQL 8.0.11 with MySQL 8.0 ODBC Unicode Driver (32-bit)
July 01, 2022 11:58PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.