Creating clean, retrievable XML output

[stjulian]

I would like to get a roadmap on learning from you folks. I need to learn
how to take an SQL view of data that I have and allow it's data to be
retrieved as an XML document in IIS.

I know how to create queries and views. I use Data Transformation Services
frequently (there isn't an XML document type in the OUTPUT options that I
can see) and, I actually get the concept of XML AUTO (for those who do not
know, this does a quick and dirty formatting of data in XML hierarchy), but
yet I do not know how to take these XML results and write them to a file,
allow it to retrieved (ONLY retrieved, not write back) from IIS as an XML
document type.

I can't imagine that I have to make IIS write all the little carriage
returns XML tags.

Maybe I don't need a file, does "XML support in IIS" create these kind of
documents on-the-fly.

Do you know of a resource (or a good book) to look at? You gotta learn
somehow.

Desparate and Serious
Julian

 

[Aaron Bertrand [SQL Server MVP]]

Have you been to http://www.sqlxml.org/ ?

There is an add-on to SQL Server 2000 that will allow you to request XML
documents from SQL Server via HTTP.

 

[stjulian]

Thank you.
What is the name of this add-on?

J

Have you been to http://www.sqlxml.org/ ?

There is an add-on to SQL Server 2000 that will allow you to request XML
documents from SQL Server via HTTP.

 

[Aaron Bertrand [SQL Server MVP]]

SQLXML.

msdn.microsoft.com/SQL/sqlreldata/XML/default.aspx (scroll down)

msdn.microsoft.com/library/en-us/dnanchor/html/anch_sqlxml.asp

microsoft.com/downloads/details.aspx?FamilyID=51d4a154-8e23-47d2-a033-764259cfb53b

microsoft.com/downloads/details.aspx?FamilyID=ca1cc72b-6390-4260-b208-2058c0bfd7de