468,315 Members | 1,429 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,315 developers. It's quick & easy.

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 Wongtrakul
Jul 20 '05 #1
1 2551
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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Iain Hosking | last post: by
1 post views Thread by TiredOfSpam | last post: by
11 posts views Thread by Peter Neumaier | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.