08-13-2015 06:19 AM
I am trying to find the most efficient way of getting a 1.8GB SAS Dataset file into a MS SQL 2014 table.
Our scenario is as follows.
As far as I can tell the Proc Append without the BULKLOAD=yes option is extremely inefficient. Can I use a Bulk Insert statement that may work? Has anyone tried it successfully on ODBC?
I am also trying to see if there is perhaps a libname Statement example which I can use that will use options like INSERT_SQL=YES INSERTBUFF=10000 that may speed up the process.
Is there anyone else in the whole wide world who has had success with a similar attempt?
Many thanks for your help.