Hi all I ahve a weird one here (Arn't they always)
I have a Dts and one of the steps calls a batch file.
When I run the DTS it fails at the batch step.
If however I click on the properties of the batch file and refresh it to say
where it is
(Its on a local Drive E then run it again it runs fine.
All the batch file does is run an EXE on E: However in the batch File E is
actually called Q: As we have a mapped Q drive for our app.

Does DTS have issues with mapped drives? However the batch file is sitting
on E and the properties say its on E:
Told you it was weird
Thanks in advance

It can be a permission problem.

I guess ur connecting o SQL with Admin priviligies..

But when DTS runs with Localsystem Account..


"Tim" <Tim (AT) discussions (DOT) microsoft.com> wrote