I have a DTS package set to run as a Job manually, it has two steps: Step 1 is to update the database via ODBC, and step two launches another program to import that data into a program called SysPro TotalFactory.
When I run the job:
on the server (windows login is Administrator, the SQLAgent runs under a mail enabled account called TF SERVER): Step1 and 2 complete successfully
On client login TF1: Step1 completes, 2 hangs
run step 2 only, works fine
On client login TBS: Step1 completes, 2 hangs
run step 2 only, works fine
The DTS Package's step1 is configured to 'goto step2' on completion.
What permission {or maybe something else?}is preventing my clients from running BOTH steps successfully, but not preventing me from running them individually from the clients?
Thanks!
Tyson
BTW, I'm using a fully patched Win2k3 server and SQL Server 2000.
When I run the job:
on the server (windows login is Administrator, the SQLAgent runs under a mail enabled account called TF SERVER): Step1 and 2 complete successfully
On client login TF1: Step1 completes, 2 hangs
run step 2 only, works fine
On client login TBS: Step1 completes, 2 hangs
run step 2 only, works fine
The DTS Package's step1 is configured to 'goto step2' on completion.
What permission {or maybe something else?}is preventing my clients from running BOTH steps successfully, but not preventing me from running them individually from the clients?
Thanks!
Tyson
BTW, I'm using a fully patched Win2k3 server and SQL Server 2000.
