Jaa


DTSBufferFlags Enumeration

Contains values that are used to register a buffer with the IDTSBufferManager90 object.

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

Syntax

'Declaration
Public Enumeration DTSBufferFlags
public enum DTSBufferFlags
public enum class DTSBufferFlags
public enum DTSBufferFlags
public enum DTSBufferFlags

Members

Member name Description
BUFF_INIT Specifies that the columns in new buffers of this type are initialized with zeros.
BUFF_NOOLEDB Specifies that the buffer does not contain status information in its rows.

Remarks

The values in this enumeration are provided to the RegisterBufferType method to control how the columns in the registered buffer type are initialized, whether status information is stored for each column in the buffer, and whether the data flow task is notified when the buffer becomes full.

If the BUFF_NOOLEDB value is not set, the memory size of a buffer is reduced because space for column status is not allocated for each column in the buffer. The memory savings equals the size of the status value, times the number of rows in the buffer, times the number of columns in a row.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace