In reply to Roger.

Roger, that's a perfect scenario for the Copy Files custom task -- you can build the download step right into your EG process flow.

In general, you can build a PowerShell script into your EG process flow by use of the System Command task. You can use that task to kick off a powershell.exe process and run a PS1 script.

If your SAS session is on a Windows platform, you can also call PowerShell from within a SAS program.