master..xp_cmdshell 'bcp ..out -U -P '
i guess you need to read up on the syntax. If that is your real command, you are not specifying any of the required values;
here's a working example:
declare @sql varchar(4000),
@rowcount int
--sample query: you would do the same to your existing bcp
set @sql = 'bcp "SELECT TOP 5 * FROM SYSOBJECTS" queryout "c:\body.txt" -c -U"sa" -P"NotARealPassword"'
--export via bcp
insert into #results
EXEC master..xp_cmdshell @sql
Lowell