xp_cmdshell - create txt file in remote computer

[snoopyyu]

I am having problem creating/copying txt file in a remote computer using the xp_cmdshell cmd from Query Analyzer:

Got the following errror message when execute:

exec master..xp_cmdshell 'copy D:\result.txt \\<myservername>\<myfoldername>\result.txt'

(where I have permission to write on \\<myservername>\<myfoldername>\result.txt)


Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-file

However, when copying it locally, like the following:
exec master..xp_cmdshell 'copy D:\result.txt D:\abc\result.txt'
This is working fine without problem.

Any ideas? Thanks in advace.

 

[snoopyyu]

Sorry, the command corresponding to the error message should be:

exec master..xp_cmdshell 'bcp &quot;SELECT * FROM pubs..authors&quot; queryout \\<myservername>\<myfoldername>\authors.txt -U sa -P -c'

 

[Zukkster]

Shouldn't you have something between the dots? A user

master..xp_cmdshell

My statements always use

EXEC master.dbo.xp_cmdshell

 

[snoopyyu]

No, this is not necessary. master..xp_cmdshell is working.
The problem was resolved. It was the windows startup service account issue. That account must be a domain account with the neccessary permission.