Is it possible to have a sqlcmd invoked in Server1 and have a txt output to Server2? I was trying to do it but is getting an <Reason: The system cannot find the path specified>
SQLCMD -S DW04\DATA_ENTRY -i \\Server2\inbox\MyTxtoutput.txt
...Maybe i'm just having a wrong sytax.
If possible, any suggestion would be appreciated.