PipelineBuffer.GetDate Method (Int32)

Applies To: SQL Server 2016 Preview

Gets the DateTime value stored in the PipelineBuffer column.

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

Syntax

public DateTime GetDate(
    int columnIndex
)

public:
DateTime GetDate(
    int columnIndex
)

member GetDate : 
        columnIndex:int -> DateTime

Public Function GetDate (
    columnIndex As Integer
) As Date

columnIndex
Type: System.Int32

The index of the column in the PipelineBuffer row.

The DateTime value stored in the PipelineBuffer column.

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

If the value of the column is null, the PipelineBuffer throws a ColumnIsNullException. You can check for a null value by calling the IsNull method.

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.