I am using a vbscript that Exec a DTS. The DTS command string is
created with global variables that are passed to the select and used to
name the file that is created.

In the DTS the file path is defined and the variable with the file name
is associated. The path points to a shared folder on the workstation I
am using while developing the DTS.

As I reached the completion of the script and DTS, the storing of the
file no longer followed the defined path, but the DTS started sending
the file to a different drive. The drive\folder to which the file is
being sent is my network user folder that is on a distributed file
system. This drive\folder is mapped and is available to me every time
I log in to the network. I am at a complete loss to explain why the
file storage location changed. I have checked the DTS and all appears
as it should.

I don't know if this is a DTS thing or a network user profile thing.
Has anyone seen anything like this?

I can be more detailed with the DTS and Script, if needed.

Thanks

Hello raglin,


Could you be a bit more specific about when you say about naming the file?
What happens if you just send the file locally i.e. not to the DFS?

Allan