IDTSBLOBObject90.SpoolThreshold Property

Article
12/03/2008

Gets or sets the number of bytes to store in memory before writing to a temporary file.

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

Syntax

'Declaration
<DispIdAttribute(102)> _
Property SpoolThreshold As Integer

[DispIdAttribute(102)] 
int SpoolThreshold { get; set; }

[DispIdAttribute(102)] 
property int SpoolThreshold {
    int get ();
    void set ([InAttribute] int plSpoolThreshold);
}

/** @property */
/** @attribute DispIdAttribute(102) */ 
int get_SpoolThreshold ()

/** @property */
/** @attribute DispIdAttribute(102) */ 
void set_SpoolThreshold (/** @attribute InAttribute() */ int plSpoolThreshold)

DispIdAttribute(102) 
function get SpoolThreshold () : int

DispIdAttribute(102) 
function set SpoolThreshold (plSpoolThreshold : int)

Property Value

An Integer that indicates how many bytes are stored in memory before writing to a temporary file.

Remarks

When the number of bytes written in memory equals the SpoolThreshold, the IDTSBLOBObject90 begins writing to a temporary file on the disk. This property cannot be changed after bytes have been added to the object.

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