I am trying to execute a batch file from the Execute Process DTS task.
It runs fine, but everytime I log off Enterprise manager, stop
MSSQLServer or reboot, the Execute Process task loses it! I have to
open its properties and repoint it to the batch file in question every
time! Others are complaining too but I cannot find a coherent reply to
this problem!

http://groups.google.ca/group/micros...4ec56e80b8426c

More samples of this trouble
http://groups.google.ca/group/micros...cc7bdfca55390c

OK I figured this out somewhat. My Execute Process task was trying to
run the batch file on E: drive - E:\somepath\mybatch.bat. The moment I
moved this to C:\somepath\mybatch.bat everything was all right! Does
anyone know how I can use any drive I want to instead of the default
C:\ drive?

Figured that one out too -


REM Important - change directory to current (any mapped drive)
CD /d %~dp0


http://weblogs.asp.net/whaggard/arch...28/362729.aspx