Extracting data from SQL Server to XML documents

Hey guys, here's the situation.
I need to extract data from SQL Server to multiple XML files, on a daily
basis.
What is the best strategy to accomplish this task?
I did try two things already. These method were using stored procedures.
The first one was the use of the System Stored Procedure sp_makewebtask
using template files. This task failed due to a dll error.
My second attempt was using the "bcp" utility. It didn't work because of the
version of SQL Server we are using right now (too old).
Is there any other ways to generate XML from SQL Server? Can we use DTS to
accomplished this task?
Thanks for the help!If you're using SQL Server 2000, you can use a variety of techniques -
including FOR XML queries, annotated schemas, etc. See SQL Server Books
Online, and install SQLXML 3.0
(http://www.microsoft.com/downloads/...DisplayLang=en.).
For earlier versions, you'd have to write a custom solution - there's no
built-in support for XML.
Graeme Malcolm
Principal Technologist
Content Master
- a member of CM Group Ltd.
www.contentmaster.com
"Dominic Feron" <dominic.feron@.dessausoprin.com> wrote in message
news:%23W6QGyiVFHA.3280@.TK2MSFTNGP09.phx.gbl...
Hey guys, here's the situation.
I need to extract data from SQL Server to multiple XML files, on a daily
basis.
What is the best strategy to accomplish this task?
I did try two things already. These method were using stored procedures.
The first one was the use of the System Stored Procedure sp_makewebtask
using template files. This task failed due to a dll error.
My second attempt was using the "bcp" utility. It didn't work because of the
version of SQL Server we are using right now (too old).
Is there any other ways to generate XML from SQL Server? Can we use DTS to
accomplished this task?
Thanks for the help!|||thx for the info!
"Graeme Malcolm" <graemem_cm@.hotmail.com> a crit dans le message de
news:u4T2%23UjVFHA.1796@.TK2MSFTNGP15.phx.gbl...
> If you're using SQL Server 2000, you can use a variety of techniques -
> including FOR XML queries, annotated schemas, etc. See SQL Server Books
> Online, and install SQLXML 3.0
>
(http://www.microsoft.com/downloads/...4a154-8e23-47d2
-a033-764259cfb53b&DisplayLang=en.).
> For earlier versions, you'd have to write a custom solution - there's no
> built-in support for XML.
> --
> Graeme Malcolm
> Principal Technologist
> Content Master
> - a member of CM Group Ltd.
> www.contentmaster.com
>
> "Dominic Feron" <dominic.feron@.dessausoprin.com> wrote in message
> news:%23W6QGyiVFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hey guys, here's the situation.
> I need to extract data from SQL Server to multiple XML files, on a daily
> basis.
> What is the best strategy to accomplish this task?
> I did try two things already. These method were using stored procedures.
> The first one was the use of the System Stored Procedure sp_makewebtask
> using template files. This task failed due to a dll error.
> My second attempt was using the "bcp" utility. It didn't work because of
the
> version of SQL Server we are using right now (too old).
> Is there any other ways to generate XML from SQL Server? Can we use DTS to
> accomplished this task?
> Thanks for the help!
>
>