Share via

IDTSOutput100.HasSideEffects Property

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Dts.Pipeline.Wrapper.Sql2012
Assembly:
Microsoft.SqlServer.DTSPipelineWrap.dll
public:
 property bool HasSideEffects { bool get(); void set(bool value); };
[System.Runtime.InteropServices.DispId(107)]
public bool HasSideEffects { [System.Runtime.InteropServices.DispId(107)] get; [System.Runtime.InteropServices.DispId(107)] set; }
[<System.Runtime.InteropServices.DispId(107)>]
[<get: System.Runtime.InteropServices.DispId(107)>]
[<set: System.Runtime.InteropServices.DispId(107)>]
member this.HasSideEffects : bool with get, set
Public Property HasSideEffects As Boolean

Property Value

Boolean

true if the component performs custom actions that are not visible to the data flow engine; otherwise, false.

Attributes
DispIdAttribute

Remarks

When you set the HasSideEffects property of an IDTSOutput100 to true, you are indicating to the data flow engine that the component to which the output belongs performs custom actions that are not visible to the engine. As a result, the component will not be removed from the execution plan when the RunInOptimizedMode property of the Data Flow task is true.

For example, a source component does not have an input, so if the HasSideEffects property of its output was not true, the data flow engine could conclude that the source performed no action, and remove it from the execution plan.

The HasSideEffects property of an IDTSInput100 will always be true on a destination component (which has no output), and the HasSideEffects property of an IDTSOutput100 will always be true on a source component (which has no input). Both properties will usually be false on a transformation component.

However the HasSideEffects property of the input of the RowCount transformation is set to true. As a result, the RowCount does not require that its output be attached to a downstream component. Thus it can be used during package debugging as a temporary destination without the need to save any data.

Applies to