This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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 directory.
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,
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
The $ shares are only available to Windows local administrators. I HIGHLY recommend against running SQL Server or SSIS as an administrator.
You need to create an actual user share and grant the SSIS service/agent rights to the share.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 92%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWJ%3C/text%3E%3C/svg%3E)
What is the batch command file doing? Is it something that could be done using a script task? If not - and the cmd file must be executed as is - you could use Process.Start in a script task to execute.
Nah, the contents of my .CMD file is in turn, calls to an executable
this:
REM *** Run xxxxx Script
C:
cd "C:\Program Files (x86)\Common Files\xxxxx\Services\"
WDRSPC !=monthly_1,mydatabase
You are aware that .NET (either C# or VB.Net) can make calls to other executables using Process.Start. Depending on the source of the executable - they may already have a .NET component available that would be much easier to setup and manage. This looks like something that could be done in a script task and I would recommend that approach - as it gives you much better control over the results.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 50%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJY%3C/text%3E%3C/svg%3E)
Hi,
Kindly check the explanation from below and they also shared the workaround of "pushd \myserver\myshare".
UNC Paths are supported in cmd.exe. You can copy files to and from them, and map drives to them. You just cannot cd to them and a UNC path cannot be the current directrory.
https://github.com/cmderdev/cmder/issues/1315
Hope this helps and please help to accept as Answer if the response is useful.
Thanks,
Jenny