DTS Programming

ForceBlobsInMemory Property

The ForceBlobsInMemory property specifies whether to store each source binary large object (BLOB) column in a transformation as a single memory allocation, even if storage objects are available from the OLE DB provider.

Applies To

Transformation Object

Transformation2 Object

Syntax

object.ForceBlobsInMemory [= value]

Part	Description
Object	Expression that evaluates to an object in the Applies To list
Value	Boolean that specifies whether to store each source BLOB column in a transformation as a single memory allocation

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetForceBlobsInMemory(VARIANT_BOOL *pRetVal);

HRESULT SetForceBlobsInMemory(VARIANT_BOOL NewValue);

Remarks

BLOBs are image, ntext, and text data types.