I have a DTS which that consist of

1. loading a .txt file
2. export table to .txt file

For both steps the file is located via an UNC, so \\server\share\filename.txt

This runs fine when started manualy or when scheduled via SQL Agent.

However, when started from ASP it fails partially. Loading the file
specified via UNC is no problem, it can determine the directory properly.
Exporting gives an error, it cannot find the directory. When replacing the
UNC in a hardcoded line like D:\directory\filename.txt it does not fail.
Since the UNC and the hardcoded directory are the same it's definitely not a
security problem, not at directory level and also not at ASP level
(IUSR_<server>).

Is this a know problem and a bug? Does anybody know how to solve it? I can
hard code it but then it can only run at ASP, not as a individual DTS routine
because it will refer to the local CD-ROM.

Please let me know,

Thanks in advance, Jeroen