I have a workspace which is scheduled through Windows Task Scheduler on a Virtual Machine. This workspace writes out to an Excel file on a mounted drive. When running the workspace manually, it has no issues. However when running through Task Scheduler, the workbench gives an error "Can't open file for writing". The target Excel is not opened anywhere and I do have writing permissions for it.
Â
Has anyone dealt with a similar issue before?
Best answer by ebygomm
Are you trying to write to a mapped network drive? If so you probably need to use the UNC path
+59Does the account that's running the task through task scheduler have access to the file/directory?
+23Does the account that's running the task through task scheduler have access to the file/directory?
I think @redgeographics is onto something, see the "Won't Get Fooled Again" section of this article! Best, Kailin
+44Are you trying to write to a mapped network drive? If so you probably need to use the UNC path
Are you trying to write to a mapped network drive? If so you probably need to use the UNC path
This worked! Thanks a million for your help.
