Bagikan melalui


PipelineBuffer.SetInt32 Method

Assigns a 32-bit signed integer to a buffer column.

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

Syntax

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

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

Parameters

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

Remarks

The SetInt32 method assigns an int to the buffer column specified by the columnIndex parameter.

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

If the value being assigned to the buffer column is not an int or the column data type is not DT_I4, 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.