'How do you execute a remote script on a remote host in R

I am trying to figure out how to execute a remote .bat file on a remote host on that host, not on the localhost from R. This syntax:

bcpImport <- shell("//remotehost/S$/SnowflakeCSV/BCP_Load_Script.bat")

runs on the local host and can't make the connection to SQL server. It needs to run on the //remotehost.



Solution 1:[1]

The answer was to define the remote server that BCP should run on with an -S remotehostname\instance name of the SQL Server instance that I was trying to load.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 user3175485