Exception from HRESULT: 0xC020204A Connecting to MySQL

Question

When I setup a ODBC Destination connection in a SSIS project to MySQL I receive the following.

Exception from HRESULT: 0xC020204A
Error at Data Flow Task - Update REDCap Employee Table [ODBC Destination [73]]: SQLSTATE: 42S22, Message: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.23-commercial]Unknown column 'emp' in 'field list';
Error at Data Flow Task - Update REDCap Employee Table [ODBC Destination [73]]: Unable to retrieve column information from the data source. Make sure your target table in the database is available.

Trying to write to a table in a MySQL database / scheme.

Answer 1

Hi @WIlliam "Bill" Lugaila ,

Unknown column 'emp' in 'field list'

1.Please check if you are trying to do the insert/update on the table with trigger.
2.If so, we can either rewrite trigger and remove 'field3' column *from insert command or * alter table 't2' and add column 'field3'.

Please refer to UNOBVIOUS "UNKNOWN COLUMN IN 'FIELD LIST'" ERROR.

Best regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I am trying to write to a table Employee in MySQL.