Thursday, March 22, 2012

Cannot delete Sequence Container Error: Collection cannot be null. Parameter name: c

I have a Sequence Container with an Exec SQL Task in it. I can't delete the task or the container. I can't disable them.

Here's how I got there:

I put a Dataflow Task and the Exec SQL Task in the container, then set a precedence constraint. Lots of complaints moving either of them. Managed to delete the Dataflow Task, but now can't do anything.

Any dieas?

Laurence

Collection cannot be null.
Parameter name: c (Microsoft Visual Studio)


Program Location:

at System.Collections.ArrayList.InsertRange(Int32 index, ICollection c)
at System.Collections.ArrayList.AddRange(ICollection c)
at Microsoft.DataTransformationServices.Design.DtsBasePackageDesigner.OnComponentRemoving(Object sender, ComponentEventArgs ce)
at Microsoft.DataTransformationServices.Design.DtrPackageDesigner.OnComponentRemoving(Object sender, ComponentEventArgs ce)
at System.ComponentModel.Design.ComponentEventHandler.Invoke(Object sender, ComponentEventArgs e)
at System.ComponentModel.Design.DesignerHost.RemoveFromContainerPreProcess(IComponent component, IContainer container)
at System.ComponentModel.Design.DesignerHost.Remove(IComponent component)
at Microsoft.DataWarehouse.Design.ClipboardCommandHelper.OnMenuDelete(MenuCommand sender, CommandHandlingArgs args)
at Microsoft.DataWarehouse.Design.CommandHandlingInfoMap.HandleCommand(MenuCommand menuCommand)
at Microsoft.DataWarehouse.Design.ClipboardCommandHelper.Microsoft.DataWarehouse.Interfaces.ICommandTarget.InvokeCommand(MenuCommand menuCommand)
at Microsoft.DataWarehouse.Design.ComponentDiagram.InvokeCommand(MenuCommand menuCommand)
at Microsoft.DataWarehouse.Design.ComponentDiagram.Microsoft.DataWarehouse.Interfaces.ICommandTarget.InvokeCommand(MenuCommand menuCommand)

More Details

No comments:

Post a Comment