Good morning. I have created a copy task that uses a variables to define the paths of the files I need to download.
The macros resolve fine and the files download but I get the following error in the log:
ERROR: Download exception occurred. Error while trying to get remote file.
When I open the .xlsx files that download I get the following message:
If I transfer the files via sftp directly to my network drive the files open normally without an error so something appears to be happening during the download in the copy task. Has anyone ever seen this and is there a fix?
Should not matter, but your SASApp looks like Linux so use a forward slash in the Download from field.
This task emits lots of messages in the Application Log, so turning that on in Tools->Options might reveal something. It's a lot to decipher, so SAS Tech Support might be able to help at that point.
Can you change the download spec to "*.xlsx" (note the dot before "xlsx")? Does that help?
Thanks, I didn't catch that before. However, I changed it and I am still having the same issues.
Should not matter, but your SASApp looks like Linux so use a forward slash in the Download from field.
This task emits lots of messages in the Application Log, so turning that on in Tools->Options might reveal something. It's a lot to decipher, so SAS Tech Support might be able to help at that point.
The forward slash fixed the issue! I've never seen anything that indicates a forward slash is needed on a wildcard macro like this in EG so I didn't even think to try that. I appreciate the suggestion and ultimately helping me figure out how to fix this!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.