I have a DTS package where I have a Execute Process Task. I am running
a .bat file that is on my local machine. The .bat file executes a .exe
file that is in the same folder as the .bat file. When I first created
it, it ran successfully. The next time I opened Enterprise Manager and
attempted to run the DTS package it failed. Whenever I browse (...)
and select the .bat file again it refreshes and it runs successfully.
I can run an infinite number of times successfully as long as I don't
close Enterprise Manger. As soon as I close it and reopen it, the DTS
package fails again. I don't think it's a security issue because I
have sysadmin rights as well as local admin rights. I tried to
duplicate this with a simple .bat file that echoed something and
paused, it works great any and every time. It seems isolated to the
..exe file. I even tried not using the .bat file and pointing directly
to the .exe file, but I get the same results. Any help would be
appreciated.