Export (0) Print
Expand All

PipelineBuffer.Item Property (Int32)

 

Applies To: SQL Server 2016 Preview

Gets the data stored in a buffer column.

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

public object this[
	int columnIndex
] { get; set; }

Parameters

columnIndex
Type: System.Int32

The index of the column in the buffer row.

Property Value

Type: System.Object

The data stored in the buffer column as an object.

The value stored in a buffer column can be accessed by using one of the data type accessor methods, such as the GetString method, or it can be accessed directly by using array access notation. Accessing a column in the PipelineBuffer by using the Item method is slower than using a data type accessor method because the PipelineBuffer detects the data type stored in the column and then calls the data type accessor method.

Buffer columns containing binary large objects (BLOB) data cannot be retrieved using the array access notation because the amount of data stored in the BLOB column may exceed the available memory. Instead, the GetBlobData method should be used.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft