SSIS HTML Parser for Screen Scraping similar to Excel Web Query?

• Jim Barnes

  SSC Veteran

  Points: 214

  More actions

  September 14, 2010 at 5:23 pm

  #226351

  Excel has this really neat Table parser to import html table data into a spreadsheet. Has anyone seen, used, built, heard rumors of, or otherwise dreamt of having similar functionality available in SSIS? This seems like a no brainer to me. It would be really nice to be able to consume reports from web based apps as data sources for SSIS/SSAS/SSRS. I think R2 has the ability to consume SSRS reports, but I'm talking about any HTML table. I really don't want to write my own classes using the HTML Agility Pack to do this. Microsoft - please connect the dots here.

  Thanks

• KABay

  SSC Enthusiast

  Points: 193

  More actions

  November 16, 2010 at 4:34 pm

  #1251645

  For what it is worth: http://www.paulswaters.com/2009/01/ssis-screen-scraper.html

  I haven't investigated it myself yet but it sounds like we have the same basic needs.