The value is too large to fit in the column data area of the buffer.

The value is too large to fit in the column data area of the buffer.


Action:
When getting columns from the REST Source, the following error message is received:
Error Message:
"The value is too large to fit in the column data area of the buffer."
Solution:

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.


    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.