SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

PipelineBuffer.SetDateTimeOffset Method

SQL Server 2012

Assigns a DateTimeOffset value to the PipelineBuffer column.

Namespace:  Microsoft.SqlServer.Dts.Pipeline
Assembly:  Microsoft.SqlServer.PipelineHost (in Microsoft.SqlServer.PipelineHost.dll)
C#
C++
F#
JScript
VB
Copy 
public void SetDateTimeOffset(
	int columnIndex,
	DateTimeOffset value
)

Parameters

columnIndex
Type: System.Int32
The index of the column in the PipelineBuffer row.
value
Type: System.DateTimeOffset
The value assigned to the buffer column.

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

If the DataType of the buffer column is not DT_DBTIMESTAMPOFFSET, an UnsupportedBufferDataTypeException occurs.

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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.