SQL Server Performance Forum – Threads Archive
Ok, this ran fine yesterday
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.
Live to Throw
Throw to Live
KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074 for your joy and resolve the issues.
BTW are ther any changes comapared to the previous month and yesterday? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
There has been no changes to this job since is ran successfully yesterday. Live to Throw
Throw to Live
Then follow the information listed on the above KBA. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>