I have no experience with this but it would seem to me from the descriptions the process would probably be:
Start SPRE session/program.
-> Connect to CAS session
---> Download file from CAS session to SPRE session.
Sort of like how you would have used SAS/Connect in the past to get access to a file that existed on a different server that was running SAS.