A couple things here.
First, the message is pretty clear. The SSIS package is failing because the login for SA, inside at least one of your SSIS connection managers is failing. Perhaps the password is correct and SA has been disabled by a DBA who knows better. Either way, someone assuring you that the SA password is correct is not the same as entering the correct password for SA. For troubleshooting reasons I'd try to use another user's credentials in that connection manager.
Second, you should not be using sa for this kind of thing (if at all). Not a good practice.
-- Itzik Ben-Gan 2001