Hi @Gena Tamarov,
Which driver did you install, 32-bit or 64-bit? And what is your ODBC connection string? If there is no problem with the driver, it may be cause by SQL Server Agent Service Account doesn’t have access to the MySQL server. Try to create a SQL Server Agent Proxy account that has sufficient permission on the MySQL server. In addition, also noted that the package protection level setting. Please refer to this similar thread.
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.