PipelineBuffer.GetSingle Method

Gets the float stored in a PipelineBuffer column.

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


Public Function GetSingle ( _
    columnIndex As Integer _
) As Single
Dim instance As PipelineBuffer
Dim columnIndex As Integer
Dim returnValue As Single

returnValue = instance.GetSingle(columnIndex)
public float GetSingle(
    int columnIndex
float GetSingle(
    int columnIndex
member GetSingle : 
        columnIndex:int -> float32 
public function GetSingle(
    columnIndex : int
) : float


  • columnIndex
    Type: System.Int32
    The index of the column in the buffer row.

Return Value

Type: System.Single
The float contained in the PipelineBuffer column.


This method works with the DT_R4 data type in Integration Services.

If the value of the column is null, the PipelineBuffer produces a ColumnIsNullException. You can check for null by calling the IsNull method prior to accessing the column data.

For a complete list of Integration Services data types and the corresponding Get and Set methods of the PipelineBuffer class to use with each type, see Working with Data Types in the Data Flow.