Hi,

I have a DTS pack that polls for a particular file, and if the file
exists continues to run. If the file isn't there, it simply sets the
remaining tasks to Complete and the pack ends.

The pack runs fine when it is manually run, with or without the file
in place.

The pack runs fine as a scheduled job, if the file is in place.

The pack fails as a scheduled job, if there is NO file in place. The
error message taken from the Job History is below:

Executed as user: OCAUS01\svc-IMS-SQL. DTSRun: Loading... DTSRun:
Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun
OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart:
DTSStep_DTSActiveScriptTask_3 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_3 DTSRun: Package execution complete.
Process Exit Code 7. The step failed.

I have read the articles related to Security issues between a locally
run job and one run by the SQL Agent, but i don't think this applies
in this case because the job runs fine if the file is in place...

When I check the log file for the pack, it shows that all individual
tasks run fine also! I'm interpreting this as meaning that the job
sends an exit code back to the job which leads the job to think that
its actually failed. Is there a way to trap this Exit Code, similar to
regulat Error Trapping...

OR, does anyone know what is goingon here? I'm using SQL Server 2000!

Many Thanks

Pete