tags:

views:

67

answers:

0

Hello, I am trying to export to xml file using bcp command with queryout and select... FOR XML PATH option.

I have a test data of 5000 records.

Expected output is:

<row>
  <column1><\column1>
  <column2><\column2>
<\row> *line break here* 
<row>
  <column1><\column1>
  <column2><\column2>
<\row> *line break here* 

However, bcp doesn't recognize a row/record from the queryout + for xml. So I think the -t or -r delimiter option from bcp doesn't work.

I want bcp to recognize the 5000 records thru -r delimiter option. Can you please help me solve this?

Thank you