All down to permissions alright, permission had to be explicitly allocated at the root folder into a read/write group.

Fairly misleading error message when ran as a job, also seems very strange that the account was able to run the first step that renamed the files but couldn't run the step to open the file and copy the data.