"text and varchar are incompatible" error

The error "The data types text and varchar are incompatible in the not equal to operator" is caused by the deprecated TEXT data type in Microsoft SQL.

Remedy it by adding a custom Field expression in the table Mapping that converts the column from TEXT to VARCHAR, and reference that expression instead of the original TEXT column.