BCP examples[
^]
taking resource from the above link I would suggest that you try removing the quotes from the destination file name
e.g.
declare @sql varchar(8000)
select @sql = 'bcp travelcatdata.dbo.communicator out c:\datafiles\comm.txt -c -t, -T -S '+ @@servername
exec master..xp_cmdshell @sql