erikd (7/10/2013)

---

Elliott Whitlow (7/10/2013)

---

erikd (7/10/2013)

---

I checked that, actually. Not only can I use xp_cmdshell to DIR the path, but I can insert the results into a table. Weird, huh?

You might have hit on something there.. I had a similar problem and the issue was the file was being written with permissions that wouldn't allow SQL to access it. So now I guess you need to see what permissions the actual file has..

CEWII

All users and groups, including Everyone, has all permissions allowed on the file, except Special Permissions. The only group that has Read and Read/Execute only are local users, which the clients\SQLService domain account isn't.

So, do I need to give "Special Permissions"? These permissions don't seem special, but what do I know?