Post reply

Basics - is there an easy way to generate XML feed?

  • December 19, 2010 at 6:58 pm

    #74627

    I have a site with several blogs that include an rss feed and it occurred to me that it would be great to also turn my sql 2005 tables into feeds.

    Is there a script or app to help with this? I know I'm asking for a simple answer to a complicated process, but I have a huge deadline coming up and I'm hoping there is a quick way to get this done.

    I would only need to include a few fields, it that helps.

    Thanks.

  • December 20, 2010 at 5:42 am

    #1264572

    I am using SSIS to do something similar.

    You can use FOR XML Path('Record'), ROOT('RecordList') at the end of your query to generate an xml result set. Then you can pass this to a script task in SSIS. You basically pass the xml result set to the script task, declare a file object, and write the content of the recordset to the file.

  • December 20, 2010 at 8:07 am

    #1264644

    Thank you. I will try that. I have no idea what that means, but it sounds a lot easier than the other solutions I've seen! I will keep you posted...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply