• I believe what is happening is that your login credentials for your CACHE database aren't being stored with the SSIS package when you deploy, so it fails to authenticate properly when you execute the package as a job.

    When deploying your package, make sure the Package Protection Level is set to the following:

    "Rely on server storage and roles for access control"