There seems to be something wrong with either SQL Server 2019 or the SSIS MySQL connectors but I've just not been successful with loading data from MySQL views to SQL Server 2019 tables.
While I've tried several ways, I'd specifically like to know if there is anyone out there that has actually successfully done this.
Note: I have loaded from MySQL to SQL Server 2017 tables using the ODBC connector. My issue is specifically with SQL Server 2019.