Global variables

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.