Cannot get the current row value of column "[ADsDSOObject].FIELDNAME" from OLE DB provider "ADsDSOObject" for linked server "ADSI". Could not convert the data value due to reasons other than sign mismatch or overflow.

Reason:

When you query a multi value field from AD, regardless you enter one value or multiple values. When you remove all the values. Erros goes away.

Solution:
Use single value fields such as employeeid, employeenumber etc.

Snapshot for error

Multi-value field

Single value field