다음을 통해 공유

  • 아티클

BLOBTempStoragePath 속성

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.dll의 Microsoft.SqlServer.DTSPipelineWrap

구문

‘선언
Public Overridable Property BLOBTempStoragePath As String
    Get
    Set
‘사용 방법
Dim instance As MainPipeClass
Dim value As String

value = instance.BLOBTempStoragePath

instance.BLOBTempStoragePath = value

public virtual string BLOBTempStoragePath { get; set; }

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

abstract BLOBTempStoragePath : string with get, set
override BLOBTempStoragePath : string with get, set

function get BLOBTempStoragePath () : String
function set BLOBTempStoragePath (value : String)

속성 값

형식: System. . :: . .String
A String that contains the path where BLOBs are temporarily written to disk.

구현

IDTSPipeline100. . :: . .BLOBTempStoragePath

주의

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 데이터 흐름의 성능 향상.