Hi,

I am trying to set up a small DTS Package and I am having filepath
issues whilst at an "Execute Process Task". Here's a brief summary of
the DTS package:

Step 1: Execute SQL Task (on completion...)
Step 2: ActiveX Script Task (on success...)
Step 3: Execute Process Task

Step 3 calls a batch file that in turn logs onto a remote server and
runs a few commands.

The problem is a weird one. In design mode of DTS I can point to the
following directory/file: C:\Automation\Test.bat. I can then save the
package and run it and the whole thing works.

If I close Enterprise Manager and then log back in and try running the
DTS Package it fails.
If I specify the UNC path as opposed to the local path it fails (but
not 100% of the time!)

Here is what gets written to a log file:

Step 'DTSStep_DTSCreateProcessTask_1' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:CreateProcessTask
'DTSTask_DTSCreateProcessTask_1': Process returned code 9009, which
does not match the specified SuccessReturnCode of 0.
Step Error code: 80040496
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4900

Any help/pointers appreciated.