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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy