• I worked out what the issue was. I was executing the package from SSSM from the development server and not the SSIS server. I executed it from this server and it run. I have now created a proxy to run the job via Sql server agent.