Variable
name
|
Description
|
DMLType
|
This
is the type of operation to perform on the row during the import
process. Allowed values are as follows:
|
·
|
dtInsert
- indicates that this row is to be inserted
|
|
·
|
dtUpdate
- indicates that this row is to be updated
|
|
·
|
dtDelete
- indicates that this row is to be deleted
|
For dmlUpdate and dmlDelete types, at least one target column needs
to have the IsKeyField value set to True.
Default value is dtInsert.
|
SkipRecord
|
Set
this value to True if you want SQL File Import to skip this row
during the import.
Default value is False.
|
RowIndex
|
This
is the current row number for the source data row that's being
processed. It is incremented by SQL File Import for each new
row.
|
_globalValues
|
This
is a global array of 100 variants that you can use to store any
additional details you want.
|