Post reply

RSS Newsfeeds to SQL?

  • March 29, 2004 at 7:00 am

    #82484

    Anyone ever done anything with importing an RSS newsfeed into a SQL database? I've looked at all the pieces/parts (the format of RSS, which is XML; how to import XML into SQL via ASP -- it's easier with .NET, but we're not .NET), but putting all the pieces together feels a bit beyond me. I'm hoping someone out there has already tackled the issue and can offer some advice.

    TIA

     

  • March 29, 2004 at 7:07 pm

    #500990

    Take a look here, this might help.

    http://home.att.net/~codeLibrary/XML/rss.htm

  • March 29, 2004 at 10:25 pm

    #501005

    XML to SQL? Check out MS SQLXML Bulk Load. I hope this will help.

  • March 30, 2004 at 5:59 am

    #501050

    The problem is I don't know enough about XML to build the XML Schema (or XSL file in Antare's reference) to map the RSS feed to the SQL database. The example on MS is just that, an example, it assumes prior knowledge of XML. Unfortunately I don't have time to learn XML in detail if I'm going to use this as a solution.

    Has anyone mapped standard (0.9, 1.0 or 2.0) RSS XML format to a SQL XML format?

     

  • March 30, 2004 at 4:02 pm

    #501211

    You need SOAP & SQLXML:

    see (RE: Soap RPC via SQLXML

    Posted 3/16/2004 9:39:00 AM) from fhanlon user.

    Regards,

    Coach James

Viewing 5 posts - 1 through 4 (of 4 total)

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