IDTSInput90.Dangling Property

Article
12/03/2008

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)

Syntax

'Declaration
<DispIdAttribute(107)> _
Property Dangling As Boolean

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

[DispIdAttribute(107)] 
property bool Dangling {
    bool get ();
    void set ([InAttribute] bool pbDangling);
}

/** @property */
/** @attribute DispIdAttribute(107) */ 
boolean get_Dangling ()

/** @property */
/** @attribute DispIdAttribute(107) */ 
void set_Dangling (/** @attribute InAttribute() */ boolean pbDangling)

DispIdAttribute(107) 
function get Dangling () : boolean

DispIdAttribute(107) 
function set Dangling (pbDangling : boolean)

Property Value

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

Remarks

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.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms