Notes Some Frustrations

Hit a problem with an agent  last week that is one of those things that gets very frustrating!

I had written an agent to get some data from a Notes DB, create a CSV and copy the file to our Cognos server to be imported later. Worked fine when run  but failed when the agent was scheduled. After some very frustrating testing worked out that the problem was that the file was being written out to a file identified by a UNC path (i.e. \\server\folder\filename.txt). This doesn't work when the Domino server is run as a service.

Not sure of the best solution... don't really want to map a drive .... ?????