PipelineBuffer.SetTime 메서드
Assigns a TimeSpan value to the PipelineBuffer column.
네임스페이스: Microsoft.SqlServer.Dts.Pipeline
어셈블리: Microsoft.SqlServer.PipelineHost(Microsoft.SqlServer.PipelineHost.dll)
구문
‘선언
Public Sub SetTime ( _
columnIndex As Integer, _
value As TimeSpan _
)
‘사용 방법
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
)
매개 변수
- columnIndex
유형: System.Int32
The index of the column in the PipelineBuffer row.
- value
유형: System.TimeSpan
The value assigned to the buffer column.
주의
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 데이터 흐름의 데이터 형식 작업.