Ok, this ran fine yesterday

[Will192]

Ok, I have not changed anything. I can run the DTS package manually by right clicking on the package in the Local Packages list. When the package is scheduled to run, it fails. It worked fine yesterday and for about a month before that on a daily basis.

The table that it's trying to load is small and there is over 500mb free in the database.

Here's the output from the failure:

DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000
DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000
DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000
DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147221499 (80040005)
Error string:
Error source:
Help file:
Help context: 0
Error Detail Records:
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun: Package execution complete.