Another BCP Export [Fail]ure
As I wrote in the comment to your previous post:


  the bcp syntax look ok. 
  I double checked with BOL and the only limitation for bcp is that 
  if you use a procedure all tables have to exist prior to bcp being executed


No temporary tables or bcp will fail!

Update 1: 
Here is an example on how to exclude columns in the format file (*.fmt) for the bcp utility:

9.0
3
1       SQLCHAR       0       7      "\t"     1     Col1         ""
2       SQLCHAR       0       0      ""       0     Col2         ""
3       SQLCHAR       0       100    "\r\n"   3     Col3         SQL_Latin1_General_CP1_CI_AS


Note the zero (0) in the length for Col2. You can find this example in the BOL of SQL Server 2008 at: 

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/30e0e7b9-d131-46c7-90a4-6ccf77e3d4f3.htm 

Or search for Using a Format File to Skip a Table Column in BOL.