Invalid field size for datatype ERROR when appending to SQL table

milts — Fri, 18 Aug 2017 01:39:19 GMT

I have a dataset extracted from a SQL table which contains nvarchar(max) fields. My DBMAX_TEXT is set to 32000 and bulkload for the libname is set to YES.

When I writeback to another SQL table, I get the error "Invalid field size for datatype".

I actually saw an old post asking a similar question but seems left unanswered.

https://communities.sas.com/t5/General-SAS-Programming/How-to-load-large-text-fields-into-SQL-Server-with-bulkload/td-p/134298

Appreciate any resolution into this issue.

Thanks!

Re: Invalid field size for datatype ERROR when appending to SQL table

ChrisNZ — Fri, 18 Aug 2017 04:15:55 GMT

Do you get no error if DBMAX_TEXT=8000 but you get an error with 8001, as implied in the other post?

topic Invalid field size for datatype ERROR when appending to SQL table in SAS Programming

Invalid field size for datatype ERROR when appending to SQL table

Re: Invalid field size for datatype ERROR when appending to SQL table