Devart SQL Server Lookup

BatchSize

The number of input rows to check for matching rows at once in one query. Default value is 5000. Please note that assigning bigger values to this property reduces the number of queries to SQL Server, but increases the query size, and too large queries may cause errors. In case of errors reduce the value of this property.

CacheSize

The number of the queried rows from the lookup object to cache. Default value is 2000.

CaseInsensitiveLookup

Determines whether matching is case insensitive. Default value is False.

Lookup Object

The name of a SQL Server database object to find matching rows from.

NoMatchAsError

Determines whether to redirect the input rows that do not match at least one row in the lookup object to the Error output. By default, False.

RetryCount

The number of times to retry querying the data in case if it fails. Default value is 5.

RetryInterval

The number of seconds before repeating an attempt to query data. Default value is 1.

UseFirstMatchInMultipleResults

Determines whether to pick the first row from the lookup object if more than one matching row is found. Default value is True. If set to false, the input rows, for which multiple matches are found, are redirected to the Error Output with the corresponding error message.

UseNullsIfNoMatchFound

Determines whether to redirect rows with matches not found to the match output and fill the corresponding lookup columns with NULLs for such rows. By default, False.