See if there is any patch or latest security updates happened, it may break ODBC connectivity using SSIS.

You case may be odbc connection for mysql connector 8.0 (source) and sql...

Try to use SA account as a Test

http://msdn.microsoft.com/en-us/library/dd440760.aspx

Play Video on this page, this will resolve all issue regarding running SSIS packages through SQL Server Agent Job.

Thanks

Muhammad Qaiser

please describe date format mentioned above?

DD/MM/YYYY or MM/DD/YYYY