Export (0) Print
Expand All

IDTSInput100.Dangling Property

Gets or sets a value that notifies the data flow engine that the input can be unattached.

Namespace:  Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly:  Microsoft.SqlServer.DTSPipelineWrap (in Microsoft.SqlServer.DTSPipelineWrap.dll)

[DispIdAttribute()]
bool Dangling { get; set; }

Property Value

Type: Boolean
true if the input is unattached during execution; otherwise, false.

The data flow task posts a validation error when an unattached input is discovered, since this normally prevents the task from running. Setting this property to true overcomes this restriction and allows components to maintain unattached inputs without causing a validation error. In contrast, if this property is set to true, and the input is attached to an output, the data flow task fails validation.

This property is typically set to true on virtual inputs. These types of inputs are used by components that support multiple inputs. The virtual input allows the component to expose an available input that can be connected to an upstream component. When the virtual input is connected to an upstream output, its Dangling property is set to false, and a new input is created with this property set to true.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft