Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

BCP out Help.

Status
Not open for further replies.

zum

Technical User
Mar 31, 2003
148
0
0
US
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.
 
add "/r\n" to the commandline. This will set the row Terminator as newline.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top