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.

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.

[stjulian]

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

J

"Aaron Bertrand [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:Ob**************@tk2msftngp13.phx.gbl...

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.

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.

[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

"stjulian" <an*******@discussions.microsoft.com> wrote in message
news:eO**************@TK2MSFTNGP14.phx.gbl...

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