I can confirm that I have a group by the name of SQLServerSQLAgentUser$MYCOMPUTERNAME$MSSQLSERVER on my Server 2008 R2 machine as well, where MYCOMPUTERNAME is my servername and the instance is...

opc.three (2/19/2013)

---

I do not think you need to add anyone to the sysadmin Role for this. Per the article you just need to add the service account you decide to...

Thanks

It is the Network Service account.

I have changed it to use the administrator account (which I know is a bad idea) and it started successfully. I guess I'll need...

Thanks, I'll research that.

Sorry, I should have said this was SQL Server 2008 R2 Express. I don't think SSIS is available.

Thanks Dwain,

I'll try that out

Sorry, I posted it originally in the 2005 area but this is 2008 and was wondering if that is why I wasn't getting any response.

Thanks Steve & Daniel,

I had copied this code from a web site where people had said that it worked, but I will follow your advice, I was most concerned about...

Ah! Thanks, I'll see if I can convert the file name to a UNC and pass that instead

Thanks Steve,

so far it looks like it has worked, now to let the users at it 🙂

Thanks. Will doing that mess with the security setup on the database?

You'll find the tool here: http://www.sqldbatips.com/showarticle.asp?ID=62

Thanks, I'll check it out.

Thanks very much, you have been super helpful. I think I grok it now. I had understood that for the remote sites to send their changes back to...