i am trying to copy data to remote server through BCP.
I am getting the error while executing the query "Error = [Microsoft][SQL Server Native Client 10.0]Unable to open BCP host data-file"
xp_cmdshell 'bcp " select * from DBNAME.._MyTempTable" queryout "\\Machinename\M$\MyData\Outbound\Inbound_08082012.csv" -c -t"," -r"" -S SqlServer -T '
when i am running the query without \\Machinename its working fine that means its not working with the remote machine.
The command is running when i am executing it from cmd prompt but xp_cmdshell is giving error.
I have checked the login under which sql server is running and the machine credentials both are same.
user is having the write permission to the folder too..
any help will be highly appreciated.