Yes, that's correct, it runs under the Service or Agent account, depending on if you execute directly or schedule in a job. The problem is that I cannot change the services to run under anything except Local for that server.

I believe the Copy with SSIS will work however, if I can pass in the connection string with credentials, I can use the domain account that has access to all three servers (my usual service account ha ha).

Ok thanks for the feedback - I will reply and let you both know if I got it to work with SSIS.

Cheers,

SSkaar