BCP with no column delimiter

• addie

  SSC Enthusiast

  Points: 194

  More actions

  May 26, 2005 at 11:06 am

  #87888

  Hi,

  I wanted to know if there is a way to Extract Data columns into a flat file as a Fixed Length file.

  BCP has a -t switch which takes tab \t as default.

  \0 puts a space as a delimiter.

  Is there anything to have no delimiter at all.

  thanks

   

   

  ---

  Regards,

  Aditee Rele

• Andreas Schwarze

  Valued Member

  Points: 66

  More actions

  May 27, 2005 at 12:57 am

  #561375

  You'll need to include a formatfile.

  See bcp.fmt in Books Online.

   

  by

  Andreas