Avoiding "Row by row" fetch method when dealing with source LOB columns
I used Data Conversion for the varchar larger than 128 as NTEXT but what removed the error for me eventually is the set Validate External Data to False.