PipelineBuffer.GetDateTimeOffset Method (Int32)

Applies To: SQL Server 2016 Preview

Gets the DateTimeOffset value stored in the PipelineBuffer column.

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

Syntax

public DateTimeOffset GetDateTimeOffset(
    int columnIndex
)

public:
DateTimeOffset GetDateTimeOffset(
    int columnIndex
)

member GetDateTimeOffset : 
        columnIndex:int -> DateTimeOffset

Public Function GetDateTimeOffset (
    columnIndex As Integer
) As DateTimeOffset

columnIndex
Type: System.Int32

The index of the column in the PipelineBuffer row.

The DateTimeOffset value stored in the PipelineBuffer column.

This method works with the DT_DBTIMESTAMPOFFSET 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.