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?
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.