Scheduled DTS package fails

[Nipon]

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

[Simon Hayes]

ni****@yahoo.com (Nipon) wrote in message news:<4c**************************@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