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.