04-09-2015 10:15 AM
I am currently trying to bulkload SAS 9.3 data into SQL Server using ODBC. Our SAS is running on Sun Solaris 10 (UNIX). According to SAS 41127 - SAS/ACCESS® Interface to Microsoft SQL Server now supports bulk loading, SAS should support bulk loading under Unix when using driver version 7.0.1 or later of the Data Access / SAS Institute ODBC driver. We are currently using driver version 7.1 (S0sqls27.so). I also added EnableBulkLoad=1 in the ODBC.ini file (please find below the ODBC entry):
Description= DB_NAME PROD
Address= [address removed]
However, I am still receiving the error "ERROR: BCP=/BULKLOAD= option not supported by this datasource." when using bulkload=yes in my libname statement as well as using bulkload=yes on dataset level.
What am I missing? What additional configuration is required for making bulkload work in my environment? Any help would be greatly appreciated.
Thank you very much in advance, kind regards,
08-12-2015 10:27 AM
I am having the same problem.
Using ODBC Driver on SAS9.3 and trying to load data into MSSQL 2014.
I have EnableBulkLoad=1 on my ODBC.ini entry but SAS says that the datasource does not support this option.
Did you manage to find a fix for this?
I found this online (We use SAS Grid 9.3 on Linux Nodes)
The ODBC standard does not directly support SQL Server bulk copy operations. see https://msdn.microsoft.com/en-us/library/ms130792(v=sql.120).aspx
Note: The Bulk Copy facility is available only when you are accessing Microsoft SQL Server data on Windows platforms.
To use this facility, your installation of Microsoft SQL Server must include the ODBCBCP.DLL file. BULKCOPY= is not available on UNIX.
08-08-2016 02:25 PM