BookmarkSubscribeRSS Feed
imdickson
Quartz | Level 8

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?

2 REPLIES 2
ChrisNZ
Tourmaline | Level 20

A bit confused here. Dont you need to change type the field in SQL server? 

imdickson
Quartz | Level 8
It's Ok.
What i meant was that nvarchar(max) in SQL does not support more than 4000 words. What i did was change to NTEXT in SQL and it works like a charm.

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 463 views
  • 1 like
  • 2 in conversation