We have a job step running an ssis package with a config file. It has worked for several months. The job started failing on a missing password error.
In researching the problem, it seems that the job was no longer referencing the config file...
it looks to be defaulting to the connection strings are they are defined witihin the ssis package (hence the missing password as the ssis package didn't have the pw).
Re-deploying the package/config file fixed the problem but the cause is unknown.
Any ideas? Anyone ever seen this happen?