Scheduled DTS package fails

Hi,

A DTS package which is running fine when execute ,always fails as
scheduled job.

I read from the previous posts about MS KB article 269074, security
and MDAC, but I don't understand and don't know how to solve it.

Please help.

My scenerio:

SERVER : MS Windows 2000 server is in a PRODUCT DOMAIN
MS SQL SERVER 7.0 SP2
- Agent started up by SYSTEM ACCOUNT and
Connection as NT Authentication

WORKSTATION (Enterprise Manager as Tool to connect MS SQL SERVER and
write and schedule DTS Package)
: MS Windows XP connect as NT Authentication
but in WORKGROUP DOMAIN

Best Regards
Nipon Wongtrakulniponw@.yahoo.com (Nipon) wrote in message news:<4c537316.0402050110.46f6f014@.posting.google.com>...
> Hi,
> A DTS package which is running fine when execute ,always fails as
> scheduled job.
> I read from the previous posts about MS KB article 269074, security
> and MDAC, but I don't understand and don't know how to solve it.
> Please help.
> My scenerio:
> SERVER : MS Windows 2000 server is in a PRODUCT DOMAIN
> MS SQL SERVER 7.0 SP2
> - Agent started up by SYSTEM ACCOUNT and
> Connection as NT Authentication
> WORKSTATION (Enterprise Manager as Tool to connect MS SQL SERVER and
> write and schedule DTS Package)
> : MS Windows XP connect as NT Authentication
> but in WORKGROUP DOMAIN
> Best Regards
> Nipon Wongtrakul

It would be helpful if you could post the error message, as it usually
gives a clue to the permissions problem. Since the agent is running
as System, that means the scheduled execution will not be able to
access network drives, for example. But without seeing the error
message, we can only guess.

Simon