August 23, 2007 at 11:44 am
Recently one of the dev servers had to be moved to a new network and the machines ip address changed. Apparently there was a maintenance plan created previously that has the local connection set to the old ip. This connection string is not editable and when you try to delete the maintenance plan, it gives a timeout error....
Anyone know a way to force the deletion of a maintenance plan or to change the Local Connection?
August 23, 2007 at 3:15 pm
you can delete the maintenace plan from SSIS instead.
* Noel
August 24, 2007 at 7:30 am
Do you mean from business intelligence studio? How do you open up a maintenance plan in SSIS?
August 24, 2007 at 9:54 am
Found it....had to find the bad package in sysdtspackages90 (using msdb) and execute sp_dts_deletepackage with the name and folderid....
Wow....talk about obscure
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply