IDTSPipeline90.BLOBTempStoragePath Property

Article
12/03/2008

Gets or sets a value that specifies the file system location where Binary Large Objects (BLOBs) are temporarily written to disk.

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

Syntax

'Declaration
<DispIdAttribute(121)> _
Property BLOBTempStoragePath As String

[DispIdAttribute(121)] 
string BLOBTempStoragePath { get; set; }

[DispIdAttribute(121)] 
property String^ BLOBTempStoragePath {
    String^ get ();
    void set ([InAttribute] String^ pbstrBLOBTempStoragePath);
}

/** @property */
/** @attribute DispIdAttribute(121) */ 
String get_BLOBTempStoragePath ()

/** @property */
/** @attribute DispIdAttribute(121) */ 
void set_BLOBTempStoragePath (/** @attribute InAttribute() */ String pbstrBLOBTempStoragePath)

DispIdAttribute(121) 
function get BLOBTempStoragePath () : String

DispIdAttribute(121) 
function set BLOBTempStoragePath (pbstrBLOBTempStoragePath : String)

Property Value

A String that contains the path where Binary Large Objects are temporarily written to disk.

Remarks

Updated text:17 July 2006

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 that is 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 Troubleshooting Package Performance.

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