question

WIlliamBillLugaila-2163 avatar image
0 Votes"
WIlliamBillLugaila-2163 asked Monalv-msft edited

Exception from HRESULT: 0xC020204A Connecting to MySQL

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.

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered

Hi @WIlliamBillLugaila-2163 ,

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

WIlliamBillLugaila-2163 avatar image
0 Votes"
WIlliamBillLugaila-2163 answered Monalv-msft edited

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @WIlliamBillLugaila-2163 ,

Welcome to contact us if you have anything about ssis package to update .

Best regards,
Mona

0 Votes 0 ·