November 14, 2007 at 8:11 am
Is it me or am I going mad, a simple task in SQL2000 has turned out to be impossible in SQL2005.
I have tried using the wizard to create a plan but at the last hurdle it throws out this error (see below).
Does anyone know why this is happening.
===================================
Saving maintenance plan failed.
===================================
Cannot find folder "Maintenance Plans\Trade".
------------------------------
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\Trade".
------------------------------
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)
November 14, 2007 at 11:35 am
Very strange. Did you try to save it with a name like trades/mypackage?
Steve
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply