• the issue ended up being that I was using a copy of the ssis package when i was trying to troubleshoot. Any changes I made was not saving to the package where the job was calling it