I am trying to import data from a remote server. My current approach is the create a script on the remote server, which is executed every time I log in using remote desktop. When I log in, a network share is mounted into the RDP session, and the script which is executed, copies a directory from the remote server to the mounted network share, thus making this directory locally available.
I want to automate this process, by creating a windows task. This task should log in a user in the remote server (RDP), and thus trigger the script execution. Is this a feasible method? Would it be possible to achieve this in another way?