• Can you set a login trigger and look for the login from BCP to the instance? I wonder if there's some issue connecting back from BCP.

    Can you dir the path you have in the command to a file with xp_cmdshell? Ensure that's correct. Also, can you perhaps hard code the BCP command that you run in SSMS in the proc and see what happens?