As far as I know there is no bulk load utility that move lot of rows from SQL server to SAS.
Try this, I am not sure whether it will work, create a permanent table in SQL server table(if you have rights to create) for your joins and then move that table to SAS in next step.
... View more
