July 2, 2022 at 6:12 am
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
July 3, 2022 at 7:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
July 6, 2022 at 9:50 am
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/
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy