Bulkload SQL Server table from SAS Dataset or CSV file From

Posted by Anil Jagtap on 21-Dec-2016 19:38

Hi All,

I have a requirement where in I need to Blukload SAS dataset / CSV file from SAS/AIX environment to MS SQL Server table. 

Recently I downloaded the trial version of Datadirect driver but just wondering how this Bulkload can be achieved. Tried to find some documentation which shows this feature but didn't find any..  

Has anybody tried already this one. Requesting for a sample SAS / UNIX code.

Thanks,

Anil

 

All Replies

Posted by darwilso on 05-Jan-2017 11:16

Hello Anil,

If you are using the ODBC driver, you can enable the bulk load option in the driver setup dialog box or programatically.  The link to the documentation is below.

media.datadirect.com/.../

For JDBC driver, you have a couple of options for performing bulk load operations.  The link to the documentation for JDBC bulk load is as follows.

media.datadirect.com/.../help.html

I hope this helps.

Darryl

This thread is closed