If you mean that you want to publish data from SQL Server using RSS, I guess one simple way would be to run a scheduled script using Windows Task Scheduler. The script itself would produce the XML to proper folder. To run the script you can use
sqlcmd[
^].