Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS Scheduled job fails...

Status
Not open for further replies.
abacaxi

abacaxi

Programmer
May 1, 2003
11
US
Working with SQL Server 7.0:

I have a DTS package that works when executed manually. However, when I schedule it, the package fails right away.

Are there any known issues regarding this situation?
Any ideas on what I can look at to fix this problem?

Thank you,
Todd
 
Sort by date Sort by votes
I believe it's permission issue.the service account of ur SQL Server agent doesnt have priviledge for acceing some folder or file in the DTS package.

Pretty common issue, u could search some similar thread everywhere
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Fsoumia
  • Locked
  • Question
DTS Logging
Replies
2
Views
154
Fsoumia
Fsoumia
WordTechinc
  • Locked
  • Question
DTS disable Daily Run 1
Replies
1
Views
86
drlex
drlex
Luvsql
  • Locked
  • Question
Errors running scheduled DTS
Replies
0
Views
63
Luvsql
Luvsql
Aluminum
  • Locked
  • Question
DTS Raiserror messages suddenly stopped displaying
Replies
0
Views
73
Aluminum
Aluminum
Azzuri
  • Locked
  • Question
DTS To SQL Server 2008
Replies
1
Views
103
mrdenny
mrdenny

Part and Inventory Search

Sponsor

Back
Top