Maintenance Plan Error since installing SP1

microsoft.public.sqlserver.tools

5 Jul 2006 5:08 AM

Kris

Prior to installing SP1 on SQL 2005 I had created a number of maintenance
plans that did backups, sent notifications etc successfully. Ever since I
installed SP1 the maintenance plans still work and I can create new
maintenance plans via the maintenance plan wizard only, but I can't modify
existing or create maintenance plans via the mintenance plan toolbox.

Sorry about the length of this error but I get the following:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to create the task.

------------------------------
ADDITIONAL INFORMATION:

Could not load type
'Microsoft.SqlServer.Dts.Design.IDtsPipelineEnvironmentService' from assembly
'Microsoft.SqlServer.Dts.Design, Version=9.0.242.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91'.
(Microsoft.DataTransformationServices.Design)

------------------------------
BUTTONS:

OK
------------------------------

===================================

Failed to create the task. (Microsoft SQL Server Management Studio)

===================================

Could not load type
'Microsoft.SqlServer.Dts.Design.IDtsPipelineEnvironmentService' from assembly
'Microsoft.SqlServer.Dts.Design, Version=9.0.242.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91'.
(Microsoft.DataTransformationServices.Design)

------------------------------
Program Location:

   at
Microsoft.DataTransformationServices.Design.DtsTypeDescriptorFilterService.FixupDesignerAttribute(DtsContainer dtsContainer, IDictionary attributes)
   at
Microsoft.DataTransformationServices.Design.DtsTypeDescriptorFilterService.System.ComponentModel.Design.ITypeDescriptorFilterService.FilterAttributes(IComponent component, IDictionary attributes)
   at System.ComponentModel.TypeDescriptor.PipelineFilter(Int32
pipelineType, ICollection members, Object instance, IDictionary cache)
   at System.ComponentModel.TypeDescriptor.GetAttributes(Object component,
Boolean noCustomTypeDesc)
   at System.ComponentModel.TypeDescriptor.CreateDesigner(IComponent
component, Type designerBaseType)
   at System.ComponentModel.Design.DesignSurface.CreateDesigner(IComponent
component, Boolean rootDesigner)
   at
Microsoft.VisualStudio.Design.VSDesignSurface.CreateDesigner(IComponent
component, Boolean rootDesigner)
   at
System.ComponentModel.Design.DesignerHost.AddToContainerPostProcess(IComponent component, String name, IContainer containerToAddTo)
   at System.ComponentModel.Design.DesignerHost.Add(IComponent component,
String name)
   at Microsoft.DataWarehouse.Design.BaseDesigner.Add(Object obj, String name)
   at
Microsoft.DataTransformationServices.Design.DtsBasePackageDesigner.Add(Object
obj, String name)
   at Microsoft.DataWarehouse.Design.BaseDesigner.Add(Object obj)
   at
Microsoft.DataTransformationServices.Design.DtsBasePackageDesigner.CreateExecutable(String moniker, IDTSSequence container, String name)

Failed to create the task. (Microsoft SQL Server Management Studio)