Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kwazi
Starting Member
1 Post |
 Posted - 2014-05-06 : 05:49:23
|
| Hi guys,I need to generate an XML file from an SQL query. In SQL 2005 and SQL 2000 makewebtask stored procedure made this easy to achieve. Is there a similar command or stored procedure in 2008 that I can use to generate an XML file from a query.Thanks.Regards,Kwazi |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-05-06 : 07:29:03
|
| You should look into using SSIS with a script task to generate the html or perhaps an SSRS report with HTML output. |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
|
|
|
|
|
Replacement of makewebtask