MainPipeClass.BLOBTempStoragePath Property

Reference

Definition

Namespace:: Microsoft.SqlServer.Dts.Pipeline.Wrapper

Assembly:: Microsoft.SqlServer.DTSPipelineWrap.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets a value that specifies the file system location where binary large objects (BLOBs) are temporarily written to disk.

public:
 virtual property System::String ^ BLOBTempStoragePath { System::String ^ get(); void set(System::String ^ value); };

[System.Runtime.InteropServices.DispId(121)]
public virtual string BLOBTempStoragePath { [System.Runtime.InteropServices.DispId(121)] get; [System.Runtime.InteropServices.DispId(121)] set; }

[<System.Runtime.InteropServices.DispId(121)>]
[<get: System.Runtime.InteropServices.DispId(121)>]
[<set: System.Runtime.InteropServices.DispId(121)>]
member this.BLOBTempStoragePath : string with get, set

Public Overridable Property BLOBTempStoragePath As String

Property Value

String

A String that contains the path where BLOBs are temporarily written to disk.

Implements

BLOBTempStoragePath

Attributes: DispIdAttribute

Remarks

When the data flow task processes a column containing BLOB data that is larger than the available memory on the system it temporarily writes data from the BLOB to the file system. This property specifies the location on the file system used by the task. You can specify multiple directories by delimiting the directory names with semicolons. By default, the directory specified by the TEMP environment variable is used.

For a brief discussion of this property and related properties that can be used to optimize the performance of the Data Flow task, see Data Flow Performance Features.

Applies to

Share via