Freigeben über


SetTime-Methode

Assigns a TimeSpan value to the PipelineBuffer column.

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

Syntax

'Declaration
Public Sub SetTime ( _
    columnIndex As Integer, _
    value As TimeSpan _
)
'Usage
Dim instance As PipelineBuffer
Dim columnIndex As Integer
Dim value As TimeSpan

instance.SetTime(columnIndex, value)
public void SetTime(
    int columnIndex,
    TimeSpan value
)
public:
void SetTime(
    int columnIndex, 
    TimeSpan value
)
member SetTime : 
        columnIndex:int * 
        value:TimeSpan -> unit 
public function SetTime(
    columnIndex : int, 
    value : TimeSpan
)

Parameter

Hinweise

The SetDateTime method assigns a DateTime value to the buffer column specified by the columnIndex parameter.

This method works with the following Integration Services data types:

The method assigns a TimeSpan value to a column of one of the following data types: DT_DBTIME or DT_DBTIME2. When the TimeSpan value requires more digits for fractional seconds than the DT_DBTIME2 column supports, the data is truncated and a DoesNotFitBufferException occurs.

If the DataType of the buffer column is not DT_DBTIME or DT_DBTIME2, 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 Verwenden von Datentypen im Datenfluss.