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?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.