suppressing sql gibberish when using ''For XML'' clause

• Rahul Bhatnagar

  SSC Rookie

  Points: 42

  More actions

  February 3, 2005 at 7:12 am

  #87388

  Greetings folks,

  I have created a sp comprising of a bunch of sql statements with 'for xml auto, elements' to get data from different sql tables and store the output in a file.

  The problem i face is that along with the xml tags and data also comes in the standard gibberesh

  Example:

  (1 rows(s) affected)

  XML_F52E2B61-18A1-11d1-B105-00805F49916B

  ------------------------------------------

  I want to suppress this sql notification from occuring . The reason is that I want to create a file based on xml tags data only that would be fed to a gateway comprising of strict schema.

  Is there some way I could specify in the sp to suppress this text.

  Thanks in advance,

  Rahul

• michanne

  SSCrazy

  Points: 2329

  More actions

  February 4, 2005 at 9:28 am

  #540716

  This is a column header:

  XML_F52E2B61-18A1-11d1-B105-00805F49916B

  You can turn off headings in qa or dts export. SET NOCOUNT ON will take care of the rowcount. Neither should effect an export..but

  The problem i had with exporting xml are the line breaks that are created. It needs to be exported as a data stream. ADO and bcp both do this.

  Hope that helps