Hi Guys, would like to know if any software can do the following. 1) the software should run a query automatically (the query can be changed), on a particular day or on every day at a particular time. 2) The data should be outputted to xml format(requirement) and it should be configurable to export to other formats (optional) Another important requirement is that the xml format should be like the below. <XMLIntegration>File Creation Timestamp <Load COLUMNS="Area, Date, keyval, value"> England, 08/01/2005, 1, 1950 England, 08/01/2005, 2, 2010 England, 08/01/2005, 3, 2020 England, 08/01/2005, 4, 2030 England, 08/01/2005, 5, 2076 … … … … </ Load > </XMLIntegration> which means that all the data generated from the query is not in general xml format, but it should be like the above format Even if the software is a costly one, please let me know. Thank You Regards, Abhi
Not sure whether this link ishttp://www.quepublishing.com/articles/article.asp?p=30081 any help to you. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
