After managing to get remote desktop access to the server I logged in using the account which runs sql server agent. The package ran in exactly the same way in...

Thanks for the advice, it is much appreciated. Security and permissions were the only thing I could link it to. I will attempt to gain access to the server and...

The account used on the server is MSSQLServer. My problem is that the server is remote, has a number of databases on there and I don't have access to it. I...

I have a feeling it is a security issue also but I can't get to the bottom of it. I am logged into the server as myself and have set...