Hoy les traigo la solución a este error que me estaba partiendo la cabeza hahaha SSIS Package in SSMS - ADO NET Source has failed to acquire the connection - Could not create a managed connection manager.
Links de descarga de controladores utilizados:
ODBC: https://dev.mysql.com/downloads/conne...
NET: https://dev.mysql.com/downloads/conne...