SSIS HTML Table Source - Web scraping without coding from any URL
- 8 years ago
Learn how to extract HTML table content placed inside TABLE tags in few clicks and save data into SQL Server. Learn more http://zappysys.com/products/ssis-powerpack/ssis-html-table-source/
==================
Description:
==================
SSIS HTML Table Source can be used for web scraping (extracting HTML table content placed inside TABLE tags). Many times valuable information stored on web pages and not available to download as traditional data file format. With this Component you can do Web content scraping to extract HTML data in few click without learning Complex APIs.
◾HTML Table scraping from any URL or HTML files stored locally (Direct URL mode or Read from SSIS variable)
◾Support for scrapping multiple URLs and combining resultset
◾Options to Skip Header rows footer rows
◾Automatically detect groups
◾Automatically assigns row number to extracted record
◾Extract HTML Table data by Table Number, CSS name used for TABLE tag or use XPath for very flexible scraping
◾Preview support without running actual package
==================
Description:
==================
SSIS HTML Table Source can be used for web scraping (extracting HTML table content placed inside TABLE tags). Many times valuable information stored on web pages and not available to download as traditional data file format. With this Component you can do Web content scraping to extract HTML data in few click without learning Complex APIs.
◾HTML Table scraping from any URL or HTML files stored locally (Direct URL mode or Read from SSIS variable)
◾Support for scrapping multiple URLs and combining resultset
◾Options to Skip Header rows footer rows
◾Automatically detect groups
◾Automatically assigns row number to extracted record
◾Extract HTML Table data by Table Number, CSS name used for TABLE tag or use XPath for very flexible scraping
◾Preview support without running actual package