I have already created a same username as my domain name on AS400.

The strange thing is that I can schedule a task to run when the job is creating a...

I am thinking maybe I can code the userid and password that will connect to that drive in the activexscript in the task. Maybe that will make it stable ?

However,...

I have tried to use 'sa' and it still doesn't work.

If I run the job on the server using 'execute the package' or run it manually, it works regardless of...

The login for the sql server agent service and the job has the same login with administrative rights.

Is this correct ? Does it have to be 'sa' or can it...

I have tried to add the same id to the AS400 box and it worked fine with schedule.

However, when I tried it later, it fails again. What could be...