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?
A bit confused here. Dont you need to change type the field in SQL server?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.