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 the job failed after the password for the account changed.

any comments will be appreciated.

cheers,

Min