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 |
|
ws5926
Yak Posting Veteran
88 Posts |
 Posted - 2005-06-16 : 11:37:27
|
| 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_1DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1DTSRun OnStart: DTSStep_DTSDataPumpTask_1DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147221499 (80040005) Error string: Error source: Help file: Help context: 0Error Detail Records:DTSRun OnFinish: DTSStep_DTSDataPumpTask_1DTSRun: Package execution complete.Live to ThrowThrow to Live |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-06-16 : 12:36:10
|
| Delete the Job, and be sure to create the job using EM on the server, not a remote EM.For unexplicable reasons, I can't create a Job from my client running Windows XP. I used to be able to do it from my Win 2000 client. |
 |
|
|
|
|
|
Ok, this ran fine yesterday