I have a Dynamic dataflow and the data source is Google Sheet Value
But there is a column which has long length as nvarchar(4000)
I have tried to set THUNK_COLUMN nvarchar(250) based on the article
but it is not working . currectly I keep getting error message like 'The value is too large to fit in the column data area of the buffer'
Is there any solution to fix it ? Many thanks