June 20, 2011 at 1:14 pm
I have a Maintainance Plan job thats failing, I need to Fix it. To fix it i need to edit the associated SSIS package. In order to Edit the SSIS package I tried exporting tha pkg but i get the following error.
TITLE: Export Package - \MSDB\Maintenance Plans\Weekly Maintenance Plan
------------------------------
The object name is not valid. The name cannot be empty.
({F6AF4F43-5399-472D-B765-E2221ECF3065})
------------------------------
ADDITIONAL INFORMATION:
The object name is not valid. The name cannot be empty.
({F6AF4F43-5399-472D-B765-E2221ECF3065})
------------------------------
BUTTONS:
OK
------------------------------
Any ideas?
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
June 20, 2011 at 1:36 pm
You should be able to edit the package right withon SSMS. why do you think you need to export it to edit it?
CEWII
June 20, 2011 at 1:50 pm
Can you please tell me how do i do that. I see options to export , import and upgrade, Bu tnot edit.
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
June 20, 2011 at 1:53 pm
I'm guessing you are connected to the SSIS server.. Connect to SQL, expand Management, Expand Maintenance Plans, and if you right click on the plan it will have a Modiy option. Voila!
CEWII
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply