Unless you consider another approach (below), you should note that the contents of the file you wish to process will be on your local box - the question there is only of whether you store it as a file or in memory, as something on the order of the scalar suggested above.

The alternate approach (which, clearly, may be way off target for your needs and capabilities) depends on what rights you have on the remote server. Can you write to the directory where the folder exists? Do you want to? Can you install and run a script on that server, to "process" the file there?

If the above are all "yes," and you're trying to avoid saving the file to your box, you might wish to consider writing the script just mentioned and running it there.