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+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
I see a response returned from the web service, but the preview in REST Source does not show any data.
CozyRoc Rest Source Component allow you to Read data from REST API. Developer can quickly extract response data from desire endpoint using HTTP Method (GET, POST) and Output into column data. In this article we will walk through some examples that ...REST Source: How to modify the [REST Source].[ResourceParameter] and [REST Source].[Resource] properties dynamically at runtime
Modify [REST Source].[Resource] dynamically at runtime: The source resource and filters are available in the data flow properties list. Follow these steps to set up an expression: Create a variable that contains the name of the Resource to be ...How to dynamically set a user parameter in a REST Connection.
Create a REST Connection with a custom configuration to use for our example. Let’s start by creating a REST Connection configuration that has authentication with two user parameters. We will set their values dynamically from variables using an ...How to implement paging in the Custom REST Configuration Editor.
There is a demonstration video that explains three different pagination templates available in the Custom REST Configuration Editor. This demonstration video only shows a brief overview that the templates are available and how they can be used to ...How to increase the Data Flow Task Plus buffer size?
To increase the Data Flow Task buffer size please complete the following steps: 1) Right-click on the Data Flow Task and select Properties. 2) On the Data Flow Task's Properties screen under Misc find fields: DefaultBufferSize and ...