trying to bcp out a file over the network, can get it to work locally
path i am using is
EXEC master..xp_cmdshell 'bcp "select * from mydatabase.dbo.myview" queryout "\\SERVER2\IT\DIRECTORY\sample.xls" -c -t\t -T -SSERVER1'
getting this error
SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Unable to open BCP host data-file
permissions on the destination server are open to everyone, folder is shared.
I have tried running this query using a domain account we have setup for both network and sql.
still getting the same error