HanShi (10/2/2013)
Execute this command from SSMS:
exec xp_cmdshell N'whoami'Make sure the account listed in the results has the correct permissions to execute the BCP executable and to write to the destination folder. Maybe you should also enter the full path to bcp.exe in the commandline.
Yes, the permissions are correct as far as I can see to run the BCP.
Sorry, perhaps I wasn't clear in my original post, I've put 'servername' etc. in the syntax shown to protect my servers name. The actual syntax contains all the correct variables for my server.