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.