PipelineBuffer.SetDateTime 方法
Assigns a DateTime value to the PipelineBuffer column.
命名空间： Microsoft.SqlServer.Dts.Pipeline
程序集： Microsoft.SqlServer.PipelineHost（在 Microsoft.SqlServer.PipelineHost.dll 中）
语法
声明
Public Sub SetDateTime ( _
columnIndex As Integer, _
value As DateTime _
)
用法
Dim instance As PipelineBuffer
Dim columnIndex As Integer
Dim value As DateTime
instance.SetDateTime(columnIndex, value)
public void SetDateTime(
int columnIndex,
DateTime value
)
public:
void SetDateTime(
int columnIndex,
DateTime value
)
member SetDateTime :
columnIndex:int *
value:DateTime -> unit
public function SetDateTime(
columnIndex : int,
value : DateTime
)
参数
- columnIndex
类型：System.Int32
The index of the column in the buffer row.
- value
类型：System.DateTime
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:
When the DateTime value requires more digits for fractional seconds than the DT_DBTIMESTAMP2 column supports, the data is truncated and a DoesNotFitBufferException occurs.
If the DataType of the buffer column is not DT_DATE, DT_DBTIMESTAMP, DT_DBTIMESTAMP2, or DT_FILETIME 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 在数据流中使用数据类型.