Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
joeatwork7
Starting Member
2 Posts |
 Posted - 2005-11-14 : 11:52:56
|
| I have two DTS packages I created and scheduled. If I run the DTS packages by right-clicking and executing, they work fine. If I go out to a cmd prompt and do DTSRun /s /u...etc...it works fine. However, when I try to use the SQL Job...it fails saying: 'The job failed. The Job was invoked by User sa. The last step to run was step 1'. If I Show Step Detail, you can see it gets to about 3000 (of 3551) records and then fails. Here is the last line of the step detail: 'PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: Copy Data from SHLFLIFE to [A... Process Exit Code 1. The step failed.'Does anyone have any ideas? |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2005-11-14 : 12:53:07
|
| The DTS job runs under a different account (sqlAgent).Make sure that account has all the rights to do the things you want it to do.Also, let say, if you design it on your machine, and it has a mapped drive to drive E on the network, the sql server may not have the same drive mapping. Here is a good website with additonal info on the issue.www.sqldts.com |
 |
|
|
joeatwork7
Starting Member
2 Posts |
Posted - 2005-11-14 : 13:42:43
|
| Thanks for the help, I will look at that site. I believe all the proper rights have been assigned...no references to map drives...I appreciate the help. |
|
|
|
|
|
|
Help with Scheduled Jobs?