Issues in creating a maintenance plan in sql 2005

Question

Post reply

Issues in creating a maintenance plan in sql 2005

BAD-DBA-DAB

SSCommitted

Points: 1966
More actions
June 30, 2008 at 2:48 am

#126251

Dear Friends,
I had encountered the following error when i tried creating a new maintenance plan in SQL server 2005. We have SQL server 2005 enterprise edition running on Windows 2003 server SP1. I have also listed out the detailed error message too. I tried installing SQLServer2005-KB933508-x86-ENU.exe, the hotfix for SP2, restarted the machine & re-registered regsvr32 dts.dll. But I still get the same error. I would much appreciate if anyone of you could throw some light on this issue which is chewing my brains out:crazy:. Thanks in advance!
Regards,
Rajesh
9.00.3050.00SP2Enterprise Edition
TITLE: Maintenance Plan Wizard Progress
------------------------------
Saving maintenance plan failed.
------------------------------
ADDITIONAL INFORMATION:
Cannot find folder "Maintenance Plans\ic_summary".
------------------------------
Cannot find folder "Maintenance Plans\ic_summary".
DETAILED ERROR MESSAGE
===================================
Saving maintenance plan failed.
===================================
Cannot find folder "Maintenance Plans\ic_summary".
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)
at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlan.Save()
at Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.PerformActions()
===================================
Cannot find folder "Maintenance Plans\ic_summary".
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToSQLServerAs(IDTSPackage90 pPackage, IDTSEvents90 pEvents, String bstrPackagePath, String bstrServerName, String bstrServerUserName, String bstrServerPassword)
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)

Viewing 5 posts - 1 through 4 (of 4 total)

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

thasteve SSCrazy Points: 2707 More actions · Answer 1

i would suggest taking a look in the sysdtspackagefolders90 table in the msdb database

MannySingh SSChampion Points: 12465 More actions · Answer 2

You need to check for the Folder here:

USE MSDB

exec sp_executesql N'exec [msdb].[dbo].[sp_dts_getfolder] @P1, @P2',N'@P1 nvarchar(17),@P2 uniqueidentifier',N'Maintenance Plans','00000000-0000-0000-0000-000000000000'

and then add the Folder like this:

Add the folder if missing:

exec sp_dts_addfolder '00000000-0000-0000-0000-000000000000','Maintenance Plans','08AA12D5-8F98-4DAB-A4FC-980B150A5DC8'

Or if you Folder Exists check here:

SELECT * FROM msdb.dbo.sysdtspackagefolders90

Then use this to update the Foldername

UPDATE msdb.dbo.sysdtspackagefolders90

SET foldername = 'Maintenance Plans'

WHERE folderid='08AA12D5-8F98-4DAB-A4FC-980B150A5DC8'

All the above code has been taken from this Guy:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=154692&SiteID=1

Maninder
www.dbanation.com

BAD-DBA-DAB SSCommitted Points: 1966 More actions · Answer 3

Dear Friends,

Thanks for your tips.

I did however manage to use a workaround by means of system sp's.

I used SQL Profiler.

Verify that the folder is missing:

exec sp_executesql N'exec [msdb].[dbo].[sp_dts_getfolder] @P1, @P2',N'@P1 nvarchar(17),@P2 uniqueidentifier',N'Maintenance Plans','00000000-0000-0000-0000-000000000000'

Add the folder if missing:

exec sp_dts_addfolder '00000000-0000-0000-0000-000000000000','Maintenance Plans','08AA12D5-8F98-4DAB-A4FC-980B150A5DC8'

I haven't tried your way, since I found out this solution before you guys replied. This way too worked well for me. Good that I have learnt something new from you all. Keep goin'..

Regards,

Rajesh

Vidhya Sagar SSCrazy Eights Points: 8216 More actions · Answer 4

[font="Verdana"]Hi,

You can also do this in GUI. The error you have given is specific and saying the folder doesn't exist. Hence you can connect to Integration services through SSMS and then create the required folder![/font]

Regards..Vidhya Sagar
SQL-Articles