Running a remote .cmd / .bat from SSIS Process Task

Question

Hi there,

I am trying to run this from this task with these two properties:

Executable: \servername\c$\Program Files (x86)\Common Files\xxx\Batch\Monthly_Total.cmd
Working directory:\servername\c$\Program Files (x86)\Common Files\xxx\Batch\

But it is failing and I getting this message:

'path.....

CMD.EXE was started with the above path as the current directoy.
UNC paths are not supported. Defaulting to Windows directory

The user has fully permissions on the remote virtual machine, it is Local Admin

Any thoughts? I remember have used this task in the past successfully against a remote server

Thanks in advance,

Answer 1

You need to create a network file share for the UNC to be functional.
Along the following:

\\server\share\theRestOfThePath