通过

MainPipeClass.BLOBTempStoragePath Property

  • 项目

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

命名空间: Microsoft.SqlServer.Dts.Pipeline.Wrapper
程序集: Microsoft.SqlServer.DTSPipelineWrap (in microsoft.sqlserver.dtspipelinewrap.dll)

语法

声明
<DispIdAttribute(121)> _
Public Overridable Property BLOBTempStoragePath As String Implements IDTSPipeline90.BLOBTempStoragePath

[DispIdAttribute(121)] 
public virtual string IDTSPipeline90.BLOBTempStoragePath { get; set; }

[DispIdAttribute(121)] 
public:
virtual property String^ BLOBTempStoragePath {
    String^ get () = IDTSPipeline90::BLOBTempStoragePath::get;
    void set ([InAttribute] String^ pbstrBLOBTempStoragePath) = IDTSPipeline90::BLOBTempStoragePath::set;
}

J# 支持显式接口实现的使用，但不支持新接口实现的声明。

JScript 支持显式接口实现的使用，但不支持新接口实现的声明。

属性值

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

备注

已更新的文本：2006 年 7 月 17 日

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 包性能故障排除.

线程安全

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.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

MainPipeClass Class
MainPipeClass Members
Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace