IDTSInput90.HasSideEffects Property

Gets or sets a value that indicates whether a data flow component should be removed or remain in the execution plan of a data flow task when its output is not attached to a downstream component and when the RunInOptimizedMode property of the Data Flow task is true.

네임스페이스: Microsoft.SqlServer.Dts.Pipeline.Wrapper
어셈블리: Microsoft.SqlServer.DTSPipelineWrap (in microsoft.sqlserver.dtspipelinewrap.dll)

구문

‘선언
<DispIdAttribute(101)> _
Property HasSideEffects As Boolean

[DispIdAttribute(101)] 
bool HasSideEffects { get; set; }

[DispIdAttribute(101)] 
property bool HasSideEffects {
    bool get ();
    void set ([InAttribute] bool pbHasSideEffects);
}

/** @property */
/** @attribute DispIdAttribute(101) */ 
boolean get_HasSideEffects ()

/** @property */
/** @attribute DispIdAttribute(101) */ 
void set_HasSideEffects (/** @attribute InAttribute() */ boolean pbHasSideEffects)

DispIdAttribute(101) 
function get HasSideEffects () : boolean

DispIdAttribute(101) 
function set HasSideEffects (pbHasSideEffects : boolean)

속성 값

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

주의

업데이트된 텍스트:2006년 7월 17일

When you set the HasSideEffects property of an IDTSInput90 to true, you are indicating to the data flow engine that the component to which the input 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 destination component does not have an output, so if the HasSideEffects property of its input was false, the data flow engine could conclude that the destination performed no action, and remove it from the execution plan.

The HasSideEffects property of an IDTSInput90 will always be true on a destination component (which has no output), and the HasSideEffects property of an IDTSOutput90 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 Row Count transformation is set to true. As a result, the Row Count transformation does not require that its output be attached to a downstream component. Therefore, it can be used during package debugging as a temporary destination without having to save any data.

스레드 보안

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.

플랫폼

개발 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

대상 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

참고 항목

참조

IDTSInput90 Interface
IDTSInput90 Members
Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace