When getting columns from the REST Source, the following error message is received:
"The value is too large to fit in the column data area of the buffer."
You can right click on Rest Source and go to Advanced editor.
From the input output columns for external and output column change the DataType for the problematic column.
The max limit for length is 4000 for DT_WSTR and if any larger than 4000 then you can use DT_NTEXT and then try and see if that fixes the issue.