BCP out Help.

[zum]

Hi,

I'm trying to bcp out some data out of a table. I need the data to be extracted into a flat file, and each entry needs to be on it's own separate line.

For example.

999903695BLUE CROSS RED SHIELD OF OREGON 00003949 99040-304
999903695BLUE CROSS RED SHIELD OF OREGON 00003949 99040-304
999903695BLUE CROSS RED SHIELD OF OREGON 00003949 99040-304

Currently when I bcp out I get multiple lines epr entry.

Here is my bcp out script I'm using.
bcp database..table out file -c -t\| -Usa -Pxxxx -SSERVER

Thanks for the help.

 

[yelworcm]

add "/r\n" to the commandline. This will set the row Terminator as newline.