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

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

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

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

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

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

Articles/Posts

MySQL to Redshift Data Load Using SSIS

Posted: June 29, 2015

Introduction – MySQL to Redshift Load Before we talk about data load from MySQL to Redshift using SSIS, first lets talk what is Amazon Redshift (or AWS Redshift). Amazon Redshift is a Cloud based Data warehouse service. This type of system also referred as MPP (Massively Parallel Processing). Amazon Redshift uses highly modified version of […]