MySQL Bugs: #99991: "[ADO NET Destination [2]] Error: An exception has occurred during data insertio

Bug #99991	"[ADO NET Destination [2]] Error: An exception has occurred during data insertio
Submitted:	26 Jun 2020 3:25	Modified:	13 Aug 2020 14:16
Reporter:	LERPONG SAHAIRAK	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / NET	Severity:	S3 (Non-critical)
Version:	8.0.20	OS:	CentOS ("[ADO NET Destination [2]] Error: An exception has occurred during data insertion, the message retur)
Assigned to:		CPU Architecture:	Any

Description:
Hi,I'm have same problem from SSIS "[ADO NET Destination [2]] Error: An exception has occurred during data insertion, the message returned from the provider is: Unknown column 'p1' in 'field list'
"
Please help for advice.

Visual Studio Professional 2017
MySQL Connector Net 8.0.20
MySQL Server 8.0.20
Microsoft SQL Server 2016

How to repeat:
I'm use ADO insert data to Mysql 8.0.20 with SSIS and found error "[ADO NET Destination [2]] Error: An exception has occurred during data insertion, the message returned from the provider is: Unknown column 'p1' in 'field list'"

Tank you for the bug report. Please try new version 8.0.21, if you get the same error message check and print here the SQL query statement maybe if actually a syntax error returned by the server.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Hello, still have the same problem on VS SSDT 2017, driver 8.0.26. Please advise?

Any Update on this issue, please? I used the latest version of MYSQL and SSIS 2017 still we are getting the same issue. Please help.