Create RSS file
-
I would like to create an RSS file through SQL Server.
I want to create a scheduled job which will replace the RSS file each day.
Any ideas?
-
This was removed by the editor as SPAM
-
Tons of code variations out there, but I haven't see a pure TSQL one. Even then I think you'd need sp_oacreate. I've got some ugly beta code I put together to generate our RSS feed, if nothing else comes up I can send you that.
Andy
-
Set up SQLXML pointing at your news database set up to accept templates only
Write a template file using for xml to produce your xml rowset. This tempate can also contain returned extra tags (such as a <root>)
This way you don't need to create a file. You can cache SQLXML content so that only one trip is made to the Database per day
look up SQLXML in bol
Keith Henry
Keith Henry
According to everyone I know I "do something with computers?" for a living, so there you go.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply