XML Template

• Paul Sp

  SSCrazy

  Points: 2314

  More actions

  April 18, 2005 at 5:13 am

  #74910

  Hi

  Does anybody know of a good way of exporting data from SQL server into an XML Template.

  Thanks

  Paul

• Wayne Lawton

  Hall of Fame

  Points: 3532

  More actions

  April 18, 2005 at 8:02 am

  #553178

  hmmm....  An interesting question.  In my opinion, the support for XML templates in SQL Server 2000 is terrible.  I typically write my own custom export routine.  Having said that, BOL describes several different ways of getting data out of SQL server into an XML format.  Are you looking for an XPATH query? If so, then "Using XPath Queries" might help you out.  "Using OPENXML" is another variation that might be what you are looking for.  Finally, a simple select with "FOR XML" might do the trick.  Each of these is a topic in BOL.

  Perhaps you could post a bit of an example to help us determine just whatyou are trying to accomplish?

  Hope this helps

  Wayne

• sliu

  Old Hand

  Points: 329

  More actions

  April 18, 2005 at 11:50 am

  #553239

  I always use .asp program to export data to .xml or .csv file. Works fine for me.

• Paul Sp

  SSCrazy

  Points: 2314

  More actions

  April 20, 2005 at 3:35 am

  #553704

  Thanks for your responses.

  I read through BOL and have managed to 'Configure SQL XML Support in IIS' using IIS Virual Directory management for SQL Server.  Running both SQL Server and IIS on a local server it gave me everything I wanted.  It enabled me to run XML queries and files from the IE address line (brilliant). 

  However, when I use the Web Server (running IIS) and the separate SQL Server (citing the Web Server as the IIS server in Virtual Directory Management) - it doesn't work.  IE (on the Web Server) returned ‘The Page Cannot be Displayed’.

  It doesn't appear from BOL that the SQL server needs IIS to be locally installed - but maybe it does?

  Interestingly enough, I can run XML queries from IE on the Webserver citing the name of my local server (running both SQL Server and IIS) in the query in the address line.

  Is there another setup issue to be addressed on the SQL Server?

  I would be grateful for any help here.

  Thanks

  Paul

  P.S.  I’ve tried to post this several times without success.  Hope this works.