08-22-2017 09:52 PM
Hi Guys. I am using SAS Data Integration Studio 4.902 to do ETL jobs.
Recently, there is a column that requires to change to 5000 characters from 2000.
I am using Microsoft SQL and SAS DI is connected through ODBC Driver.
My column in SQL is nvarchar(MAX) and if i do Append in Table Loader, I will get this error:
ERROR: Error binding parameters: [Microsoft][SQL Server Native Client 11.0]Invalid precision value
I did some checking online but there are 2 "solutions" suggested:
1) set bulkload=yes in libname statement(Doesn't work)
2) use NCHAR(MAX) as NVARCHAR(MAX) only allows up to 4000 words.
May i know if there is alternative solution?
08-23-2017 04:44 AM