Compartilhar via


Propriedade do RDL IDTSPipeline100.BLOBTempStoragePath

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 (em Microsoft.SqlServer.DTSPipelineWrap.dll)

Sintaxe

'Declaração
Property BLOBTempStoragePath As String 
    Get 
    Set
'Uso
Dim instance As IDTSPipeline100 
Dim value As String 

value = instance.BLOBTempStoragePath

instance.BLOBTempStoragePath = value
string BLOBTempStoragePath { get; set; }
property String^ BLOBTempStoragePath {
    String^ get ();
    void set (String^ value);
}
abstract BLOBTempStoragePath : string with get, set
function get BLOBTempStoragePath () : String 
function set BLOBTempStoragePath (value : String)

Valor da propriedade

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

Comentários

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 the section "Improving the Performance of the Data Flow Task" in Tarefa de Fluxo de Dados.

Consulte também

Referência

IDTSPipeline100 Interface

Namespace Microsoft.SqlServer.Dts.Pipeline.Wrapper