Thank you Grey Cat,

I did what you told me to, but the package still fails.

the only way i can avoid the failure is to change the 'credential' password under security...

One question for this:

What if the credential's password get changed? I had been using one credential and created a proxy to run the SSIS package in SQL Agent jobs, but...