I've tried changing the job settings to run 32 bit, still doing the same. I don't think OLEDB 12.0 is installed. Can't install it as admin/security guy is off, and their very strict on security.
I created the job to pull the data from an Excel sheet, load it to a table and create the job in the agent.
Another interesting thing that happened was on another server I had same issue, however changing it to run 32 bit worked, why not on this server?
Any thoughts on how to get it to run much appreciated.