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

HTML source example

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

SSIS HTML Table Source – Using XPath to Extract Table data

HTML table source Xpath example

SSIS HTML Table Source – Using XPath to Extract Table data

SSIS HTML Table Source – Select Columns

HTML table source Column tab

SSIS HTML Table Source – Select Columns.

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

 

HTML table source extract links

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

HTML code – verify in the page body if it is a <table>

HTML code, inspect page

HTML code – Verify it is table

Articles / Tutorials

Click here to see all articles for [SSIS HTML Table Source] category


Read HTML Table in SSIS – Extract / Download Links / Images

Read HTML Table in SSIS – Extract / Download Links / Images

Introduction In this post you will learn how to extract data from web pages using SSIS. In other words, read HTML Table in SSIS, then Loop through extracted links and finally download files. To achieve this scenario we will use SSIS HTML Source and REST API Task.     Step-By-Step To achieve desired extraction from web pages […]


How to read and write data to HTML in SSIS

How to read and write data to HTML in SSIS

Introduction to read and write data to HTML in SSIS In this article, we will show how to send values from an SSIS Variable to an HTML file. We will use the SSIS Advanced File System Task to store the list of system files of a folder into a variable and then we will use […]

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 […]

References

Click here to learn more about System Requirements
Download View All Tasks Like This