DTS works by itself, but not when run from job

[stiej]

Hi,

I have a dts that contains just one step and that's an ActiveX script. the script reads a text file into a variable, writes a new text file and executes the sql stored in variable that got populated from the file read.

When i run the DTS from the Designer it all works great, though when scheduled to run from a job then nothing at all happens. I can see the SQL hasn't been executed and the new text file doesn't get written, but the job succeeds without error and the DTS log shows that the activexscript task did get [apparently] execute.

Any ideas, why it doesn't work from a job?

Many thanks...

 

[123FakeSt]

Most likely a network path is not accessible when run by the SQL Server Agent which is only a local account.

The early bird gets the worm, but the second mouse gets the cheese.