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.