SSIS Send HTML Email Task

SSIS HTML Table Source

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
Download Help File Buy
View All Tasks Like This
ScreenshotsArticles / Useful LinksSystem Requirements
SSIS HTML Table Source - Using Table Number to Extract Table data

SSIS HTML Table Source – Using Table Number to Extract Table data

 

SSIS HTML Table Source - Using XPath to Extract Table data

SSIS HTML Table Source – Using XPath to Extract Table data

 

SSIS HTML Table Source - Select Columns

SSIS HTML Table Source – Select Columns.

 

SSIS HTML Table Source - Extract Links/Images from Table cell for each row and column

Extract Links/Images from Table cell for each row and column

 

SSIS HTML Table Source - Extract HTML Table and View in DataViewer

SSIS HTML Table Source – Extract HTML Table and View in DataViewer.

See Also

Articles/Posts

Amazon Redshift

MySQL to Redshift Data Load Using SSIS

Contents1 Introduction – MySQL to Redshift Load2 Video Tutorial3 Right way but hard way3.1 Steps for Amazon Redshift Data Load from On-Premise files or RDBMS (e.g. MySQL, SQL Server)4 Doing it easy way4.1 Should I use SSIS to load Redshift Database?4.2 Command line approach for MySQL to Redshift data loading5 Setup your Amazon Redshift Cluster6 […]

1 comment

References

  • .net framework 3.5 or higher must be installed
  • SSIS Runtime: To execute SSIS package you will need one or more versions of SQL Server Integration Services 2005/2008/2008 R2/2012/2014 or 2016
  • To design SSIS 2012 package SSDT (VS 2010 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2014 package SSDT-BI (VS 2013 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2016 package SSDT-BI (VS 2015 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2005, 2008, 2008 R2 packages BIDS (VS 2005,2008 Shell – Business Intelligence Development Studio) must be installed.
  • Supported Client Operating Systems: Windows 7, Windows 8, Windows 8.1
  • Supported Server Operating Systems: Windows Server 2003/R2, Windows Server 2008/R2, Windows Server 2012/R2
Download View All Tasks Like This