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
sql
No comments:
Post a Comment