@ChrisNZ thanks for the thoughts offered. By the way, I did some further digging and it seems that for Greenplum, SAS uses the same DataDirect ODBC driver that I was using in the first instance. Note that I did find the following text in a 2012 SAS Global Forum document. Any way to find out if that is still the case (since my load is from a Windows environment to Greenplum which is on a Linux environment). GREENPLUM Bulkload Support Using Pipes on UNIX Bulkloading capabilities have been extended on UNIX platforms to loadtables load pipes. To leverage this new feature, you must add the BL_USE_PIPE=YES option when starting the bulkload facility: data user.dbtab (bulkload=yes bl_format='CSV' bl_quote='"' bl_host='mypc.na.acme.com' bl_port='8080' bl_protocol='gpfdist' BL_USE_PIPE=YES); set work.worktab; run; We have seen a 30 percent average performance gain in load speed when using pipes rather than traditional flat files. Greenplum does not currently support pipes on Windows platforms.
... View more