0

I have an SSIS package that pulls some data out of SQL Server into a .csv file, then copies the file to a network location (uses Robocopy). Runs fine as a SQL Agent job. When I use DtExec from my own machine, Robocopy fails with 'Access is denied.' The same error occurs regardless of which network location I enter. If I use Robocopy to try to copy to a local drive on the server instead, it works fine. DtExec is running as my own account. If I use remote desktop to login to the server (again with my own account) I can access all the network shares, and run Robocopy directly no problem. I am using UNC names throughout - no drive letters anywhere.

Is it possible DtExec is running under some low-privilege account on the server that cannot access any network resources? If so, any ideas on how to work around it?

The other other Alan
  • 1,868
  • 12
  • 21
  • Have you tried using the File System Task in SSIS to move files? – Jason B. Aug 17 '16 at 21:22
  • @JasonB. no, might be a good test, but won't work in practice - we started with the basic File System task, but had to move to Robocopy as we are moving very large files over unreliable WAN. Thanks. – The other other Alan Aug 17 '16 at 21:28
  • Are you able to access these network locations directly (without RDP)? Just paste the network location to the address bar of any windows explorer window. Share permissions of a folder might be different then actual file system permissions so files might be accessible through RDP but unavailable through network SMB. – infiniteRefactor Aug 17 '16 at 21:28
  • @infiniteRefactor - yes I can access the network locations directly, no problem. Much appreciated, though – The other other Alan Aug 17 '16 at 21:30
  • Can you verify the credentials that DTEXEC and Perfmon are using? One way to do this is using PerfMon. See http://improve.dk/solving-access-denied-errors-using-process-monitor/ – Cory Aug 17 '16 at 21:46

0 Answers0