Error running scheduled job

[Jenns]

I get the following error running a scheduled job using the SQL Server Agent. I'm trying to run a DTS which empties a table then copies a text file into it. If I run the DTS manually, it completes with no problem.

Error is the error:
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data from Status to [DunTrade].[dbo].[Status] Step DTSRun OnError: Copy Data from Status to [DunTrade].[dbo].[Status] Step, Error = -2147217887 (80040E21) Error string: Errors occurred Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217887 (80040E21); Provider Error: 0 (0) Error string: Errors occurred Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: Copy Data from Status to [DunTrade].[dbo].[Status] Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.

Can anyone tell me what that means??

I'm running SQL Server 7 on NT.

Thanks!
Jenn

 

[tlbroadbent]

The most common cause of a Job failing to run is lack of permissions. When you run the Job manually, it runs with your user account. Whe SQL starts it, it runs with the SQL Account. Make sue the SQL account has required permissions.

If you need further info check faq183-280. You also find info at

http://support.microsoft.com/support/kb/articles/Q269/0/74.ASP.

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.