sql2005 maint plan return error

Hi,
I have a maint plan that always failed and return me an error below from the job output, do anyone know how do we get this resolved?
I'm running sql2005 with windows 2003 server and SP2

The job failed with following msg.

Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3033.00 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started:  3:12:21 AM
Error: 2008-02-04 03:36:46.21
   Code: 0xC0024104
   Source: Reorganize Index
   Description: The Execute method on the task returned error code 0x80131501 (An exception occurred while executing a
   Transact-SQL statement or batch.). The Execute method must succeed, and indicate the result using an "out" parameter.
End Error
Error: 2008-02-04 03:55:53.79
   Code: 0xC0024104
   Source: Rebuild Index Task
   Description: The Execute method on the task returned error code 0x80131501 (An exception occurred while executing
   a Transact-SQL statement or batch.). The Execute method must succeed, and indicate the result using an "out" parameter.
End Error
Error: 2008-02-04 04:09:45.09
   Code: 0xC0024104
   Source: Update Statistics Task
   Description: The Execute method on the task returned error code 0x80131501 (An exception occurred while executing
   a Transact-SQL statement or batch.). The Execute method must succeed, and indicate the result using an "out" parameter.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started:  3:12:21 AM
Finished: 4:09:46 AM
Elapsed:  3444.42 seconds


motioneyeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

maradamCommented:
Maybe try to apply cumulative hotfix after SP2. I have version 9.0.3042 on my box.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dfhuber2Commented:
Did applying one of the cumulative hotfixes after SP2 resolve this problem and if so, which one?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.