SAS Grid to Sqlserver data upload performance.

[smijoss1]

Hi 

The "insertbuff=" parameter is no longer working for Sqlserver. (Since the latest update on sas Grid) 

the Libname statement works fine. but when it tries executing the proc append , it gives "Error: The connection to the server has been lost."  Error.

i have about 10 table contain about 300K to 400K records each. so without the insert buffer it take a Loooong time.

has insertbuff  been replaced with any other option ?  Since Bulkload  does not work on SAS Grid what other option do I have  ?

libname mydblib sqlsvr datasrc=xxx     user=xxx   password=xxx schema=xxx DIRECT_EXE=delete DBCOMMIT=1000 ReadBuff= 10000   ;

proc append base=mydblib.Smijo_Class data=sashelp.class;
Run;

libname mydblib clear;

[ballardw]

To help someone that knows more on this topic than I do you might want to mention which release of SQL Server you are connecting to.

[smijoss1]

Thank you for replying. Here are the details of the Sqlserver. 

SAS Grid  Version : 9.04.01M6P110718
SYSHOSTINFOLONG Linux LIN X64

Sqlserver version : 

[SASKiwi · Accepted solution]

I suggest you work with SAS Tech Support on this one. INSERTBUFF shouldn't cause dropped database connections.