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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-29 : 08:11:55
|
| Jerome writes "I have been attempting to export data from a table on a daily to an xml file. Seemed simple at first to set it up using DTS but this does not work. I'm fairly new to SQL and have managed to obtain an activeX script that does the job including appending the date to the file each time the job is run, my problem is that the ISP I use does not support SQL 2000 and the script doesn't seem to work on SQL 7.0. Can someone give me a script that I can use export data from a file every day as XML and give it a new filename each time. Your help would be appreciated as I only have a demo of SQL 7.0 and not much time to sort it. Thanks" |
|
|
|
|
|
Exporting XML