Maintenance Plan failure

Question

Post reply

Maintenance Plan failure

Vishal Singh

SSCertifiable

Points: 5830
More actions
September 1, 2010 at 3:34 am

#142525

Hey guys,
All of so sudden, some of my maintenance plans reporting failure with the below error:
Description: The package path referenced an object that cannot be found: "\Package\Index ReBuild and Backup.Disable". This occurs when an attempt is made to resolve a package path to an object that cannot be found. End Warning DTExec: Could not set \Package\Index ReBuild and Backup.Disable value to false.
I am running on SQL Server 2005 (SP3) on win 2003 enterprise 32 bit.
Needs to mentioned that nothing has changes on any of the side which could be the prime suspects for this failure.
The Job owner, configurations everything is same.
I browse through the forums but did not find any possible solutions or guides for this issue. Is there anybody else who has the same problem or faced the same problem in the past?
-Forum Etiquette: How to post Performance Problems[/url]
-Forum Etiquette: How to post data/code to get the best help [/url]

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

You may find this discussion useful

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 2

Adiga (9/1/2010)
You may find this discussion useful

Not much. I already went through this post and tried re-registering the DTS.dll several times but even after successful re-registeration that did not resolves the issue.

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

Rick.Cornell.SME SSCrazy Eights Points: 8597 More actions · Answer 3

Rick.Cornell.SME

SSCrazy Eights

Points: 8597

September 3, 2010 at 9:12 am

#1216223

Have you try recreating the package?

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 4

Twinsoft SME (9/3/2010)
Have you try recreating the package?

Yes, but the same error appears.

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

Minaz Amin SSChampion Points: 11052 More actions · Answer 5

What changed have you made to the server?

Check if the job owner have suifiicient privilleges?

"More Green More Oxygen !! Plant a tree today"

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 6

Minaz Amin (9/7/2010)
What changed have you made to the server?
Check if the job owner have suifiicient privilleges?

Nothing has changed. Job owner has SA permission.

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 7

Vishal Singh (9/6/2010)
Twinsoft SME (9/3/2010)
Have you try recreating the package?
Yes, but the same error appears.

Did you restart the sql agent ? and did you try to execute plan plan manually ?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 8

Bhuvnesh (9/7/2010)
Vishal Singh (9/6/2010)
Twinsoft SME (9/3/2010)
Have you try recreating the package?
Yes, but the same error appears.
Did you restart the sql agent ? and did you try to execute plan plan manually ?

yes, tried both but nothing worked.

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]