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.