If the condition is false or NULL, regardless of the Lookup transformation properties, the NewLookupRow value is 0 and the Integration Services does not update the dynamic lookup cache with any row inserts or updates.

If the row exists in the cache and you enable Insert Else Update or Update Else Insert, the NewLookupRow value is 1 and Integration Service updates the new row in the cache.

If the row does not exist in the cache and you enable Insert Else Update or Update Else Insert, the NewLookupRow value is 2 and Integration Service inserts the new row in the cache.