SetNull-Methode
Assigns nullNothingnullptrunitein NULL-Verweis (Nothing in Visual Basic) to a buffer column.
Namespace: Microsoft.SqlServer.Dts.Pipeline
Assembly: Microsoft.SqlServer.PipelineHost (in Microsoft.SqlServer.PipelineHost.dll)
Syntax
'Declaration
Public Sub SetNull ( _
columnIndex As Integer _
)
'Usage
Dim instance As PipelineBuffer
Dim columnIndex As Integer
instance.SetNull(columnIndex)
public void SetNull(
int columnIndex
)
public:
void SetNull(
int columnIndex
)
member SetNull :
columnIndex:int -> unit
public function SetNull(
columnIndex : int
)
Parameter
- columnIndex
Typ: System. . :: . .Int32
The index of the column in the buffer row.
Hinweise
The SetNull method assigns null Nothing nullptr unit ein NULL-Verweis (Nothing in Visual Basic) to the buffer column specified by the columnIndex parameter.
This method works with the DT_NULL data type in Integration Services.
You can use the SetNull method to insert a null value into a column of any type except for the BLOB data types:
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.