SAS EG Copy Task ERROR: Download exception occured

[elwayfan446]

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?

[ChrisHemedinger]

Can you change the download spec to "*.xlsx" (note the dot before "xlsx")?  Does that help?

[elwayfan446]

Thanks, I didn't catch that before.  However, I changed it and I am still having the same issues.

[ChrisHemedinger · Accepted solution]

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.

[elwayfan446]

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!