Bulkload SQL Server table from SAS Dataset or CSV file From AIX environment - Forum - DataDirect Connect - Progress Community

Bulkload SQL Server table from SAS Dataset or CSV file From AIX environment

 Forum

Bulkload SQL Server table from SAS Dataset or CSV file From AIX environment

This question is not answered

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
  • 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