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