Hi,

SQL server version - Microsoft SQL Server 2005 - 9.00.4035.00 (X64)

Recently I have started getting the following error when i try to create a
maint. plan.

Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

I have read some articles about a hotfix that can be applied to fix this
issue but they are all pertaining to a different service pack level which is
not equivalent to sp3.

The detailed description is as follows,

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

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

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

Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

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

at Microsoft.SqlServer.Dts.Runtime.Sequence.get_Prope rties()
at
Microsoft.DataTransformationServices.Design.DtsBas eDesigner.PreFilterProperties(IDictionary properties)
at
Microsoft.DataTransformationServices.Design.DtsPro pExpressionsDesigner.PreFilterProperties(IDictiona ry properties)
at
Microsoft.DataTransformationServices.Design.DtsCon tainerDesigner.PreFilterProperties(IDictionary properties)
at
Microsoft.DataTransformationServices.Design.DbMain tSequenceDesigner.PreFilterProperties(IDictionary properties)
at
System.ComponentModel.Design.ComponentDesigner.Sys tem.ComponentModel.Design.IDesignerFilter.PreFilte rProperties(IDictionary properties)
at
System.ComponentModel.Design.TypeDescriptorFilterS ervice.System.ComponentModel.Design.ITypeDescripto rFilterService.FilterProperties(IComponent
component, IDictionary properties)
at
Microsoft.DataTransformationServices.Design.DtsTyp eDescriptorFilterService.System.ComponentModel.Des ign.ITypeDescriptorFilterService.FilterProperties( IComponent component, IDictionary properties)
at System.ComponentModel.TypeDescriptor.PipelineFilte r(Int32
pipelineType, ICollection members, Object instance, IDictionary cache)
at System.ComponentModel.TypeDescriptor.GetProperties Impl(Object
component, Attribute[] attributes, Boolean noCustomTypeDesc, Boolean
noAttributes)
at System.ComponentModel.TypeDescriptor.GetProperties (Object component)
at Microsoft.DataWarehouse.Design.Cud.VsTransaction.C hangeProperty(Object
obj, String propertyName)
at
Microsoft.DataTransformationServices.Design.DtsBas ePackageDesigner.CreateExecutable(String moniker, IDTSSequence container, String name)

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

Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

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

at
Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSProper tiesProvider90.get_Properties()
at Microsoft.SqlServer.Dts.Runtime.Sequence.get_Prope rties()

TIA,
MK

Verify that your client tools have been patched to SP3 - I am betting that
they are not at that level and that is why you are getting these errors.

"Manoj Kumar" <ManojKumar (AT) discussions (DOT) microsoft.com> wrote

Hi Jeff,

Yes, that was the issue. I was about to reinstall client tools & apply
service packs.
The issue has been taken care of by elevating the patch level on client tools.

Thanks,
--
Manoj Kumar


"Jeffrey Williams" wrote:

you are welcome - thanks for the feedback.

"Manoj Kumar" <ManojKumar (AT) discussions (DOT) microsoft.com> wrote