MainPipeClass.BLOBTempStoragePath Property

Article
12/15/2008

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

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

Syntaxe

'Déclaration
<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# prend en charge l'utilisation d'implémentations d'interface explicites, mais pas la déclaration de nouvelles implémentations d'interface explicites.

JScript prend en charge l'utilisation d'implémentations d'interface explicites, mais pas la déclaration de nouvelles implémentations d'interface explicites.

Valeur de propriété

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

Notes

Texte mis à jour :17 juillet 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 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 Dépannage des performances du package.

Sécurité des threads

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.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

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

Partager via