IDTSBLOBObject100.SpoolThreshold Property

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
Property SpoolThreshold As Integer 
    Get 
    Set
'Usage
Dim instance As IDTSBLOBObject100 
Dim value As Integer 

value = instance.SpoolThreshold

instance.SpoolThreshold = value

int SpoolThreshold { get; set; }

property int SpoolThreshold {
    int get ();
    void set (int value);
}

abstract SpoolThreshold : int with get, set

function get SpoolThreshold () : int 
function set SpoolThreshold (value : int)

Property Value

Type: System.Int32
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 IDTSBLOBObject100 begins writing to a temporary file on the disk. This property cannot be changed after bytes have been added to the object.

See Also

Reference

IDTSBLOBObject100 Interface

Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace