IDTSBuffer100.LockData Method

Locks the data in an IDTSBuffer100.

Namespace:  Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly:  Microsoft.SqlServer.DTSPipelineWrap (in Microsoft.SqlServer.DTSPipelineWrap.dll)

void LockData()

Before accessing the data in an IDTSBuffer100, data flow components should call the LockData method of the buffer. This method locks the data in the buffer in memory and prevents the IDTSBufferManager100 from swapping it out to disk.

In low memory situations, the IDTSBufferManager100 attempts to create memory space by swapping unlocked buffers out of memory and to disk. Attempts to access the data within a buffer fail on buffers that have not been locked. However, calls to get data about the buffer itself, such as GetRowCount or GetColumnCount, succeed because only the actual data within the buffer is swapped to disk, not the descriptive data about the state or type of the buffer.

Managed data flow component developers do not need to call this method because the managed PipelineBuffer automatically locks and unlocks the buffer.

Community Additions