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 |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2003-03-13 : 23:29:04
|
| I want to be able to do a series of selects and wrap in HTML with DTS save the file to a directory then schedule this for a nightly job. I don't need sp_makewebtask.Has anyone done something similar and willing to share code or experience. |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-03-14 : 14:08:28
|
| If you are on SQL2000 it would probably be easier/more efficent to export as xml. You can then use an xsl file to transform the results when people view the report. You can use a DTS package containing an xml template query to do this very easily.HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
 |
|
|
|
|
|
Save Results to HTML