Included in SSIS PowerPack

SSIS HTML Table Source

Scrape HTML tables from web pages or local HTML files straight into your SSIS Data Flow, without coding.

HTML Table Source extracts data placed inside HTML TABLE tags from any URL or locally stored HTML file. Valuable data often sits on web pages with no file to download; pick the table by number, CSS class or XPath, read div-based tables with custom XPath, extract links and images from cells, and preview the rows without running the package.

The trial includes HTML Table Source and every other PowerPack component

HTML Table Source extracting table data from a web page using the table number
Extract a table from a web page by its table number, then preview the rows.

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

Also rated on Capterra★★★★★ , Trustpilot★★★★★ and BBBA+ — see why teams trust ZappySys

At a glance

What HTML Table Source can do

HTML Table Source scrapes data placed inside HTML TABLE tags from web pages or local HTML files. Valuable information is often published on web pages without a downloadable data file; this component extracts it in a few clicks without coding.

Scrape URLs or local files

Extract HTML table data from any URL or locally stored HTML files without coding.

  • AccessMode: Direct, Variable or Connection
  • Multiple URLs or paths (one per line) with combined results
  • TreatInputAsHtmlString to parse a raw HTML string

Component help

Table number, CSS or XPath

Pick the table to extract by number, by CSS class or with an XPath expression.

  • TableExtractMethod: ByNumber, ByCss, ByXPath, ByXPathCustom
  • TableNumber, TableClass or TableXPath (e.g. //table[@class='mydata'])

See the extract modes

Div-based tables

Read tables built from div or other custom nodes with your own row and cell selectors.

  • RowXPath (e.g. ./div[contains(@class,'row')])
  • CellXPath (e.g. ./div[contains(@class,'cell')])

Component properties

Extract links & images

Output hyperlinks and images from each table cell as extra columns.

  • OutputLinks adds _Links columns; OutputImages adds _Images columns
  • MaxLinksPerColumn and MaxImagesPerColumn

Extract / download links guide

Header, skip rows & groups

Use a header row for column names, skip header or footer rows, detect grouping rows and number each extracted record.

  • HasHeaderRow, HeaderRowNumber, SkipRowsTop and SkipRowsBottom
  • MaxRows works like TOP N
  • EnableGroupDetect outputs the group (rows using colspan) in a __groupName column

Component properties

Extra columns via XPath

Add extra output columns taken from any node on the page with XPath.

  • ExtraColumns: Title1=//h1[contains(@class,'main-title')]

Component properties

Preview & column control

Preview extracted data without running the package, then select, rename and retype columns.

  • MaxGuessRows rows scanned to detect data types
  • DoNotFailWhenExprYieldsNoResult to continue when a table or XPath is not found
  • CharacterSet (e.g. windows-1250)

Component properties

SQL Server 2012–2025 & ADF

Runs in your environment on SQL Server 2012–2025 and Azure-SSIS.

  • SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit)
  • Azure Data Factory (SSIS IR)
  • Design packages in Visual Studio 2017, 2019, 2022, or 2026
  • Windows only (64-bit OS): Windows 7–11 or Windows Server 2012–2025

Compatibility and requirements

See all features
  • HTML table scraping from any URL or local HTML file (direct value or SSIS variable)
  • Scrape multiple URLs and combine the result set
  • Extract by table number, CSS class used on the TABLE tag or XPath
  • Custom XPath for row and cell nodes to read div-based tables
  • Extract links and images from table cells
  • Options to skip header and footer rows
  • Automatically detect groups
  • Automatically assign a row number to each extracted record
  • Extra columns from any page node using XPath
  • Parse a raw HTML string instead of a URL
  • Preview support without running the actual package
  • Select columns, rename them and change data types
  • Trim whitespace, character set (e.g. windows-1250) and an option not to fail when a table or XPath finds nothing
  • Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory

Runs in your environment ·

SQL Server 2012–2025

and Azure-SSIS · Read the FAQ

How it works

From the toolbox to your first run.

Point at a URL or file, choose how to find the table, then preview the rows.

Extract a table by its position on the page.

Set Access Mode to Direct and enter a URL such as https://en.wikipedia.org/wiki/World_population. Select the ByNumber extract method, set the table number (starting at 1) and click Preview.

  • URL(s) or local HTML file paths, one per line
  • Direct value, SSIS variable or connection
  • Header row, skip rows and TOP N options
HTML Table Source extracting table data by table number

Inside the UI

Key settings, as they appear in SSDT.

Real screens from the HTML Table Source product page. Step through them, or open any shot at full size.

Extract a table by number

Pick the table by its position on the page and preview the extracted rows.

Compatibility and requirements

Designed to stay inside your SSIS runtime.

  • SQL Server 2012 through 2025, 32-bit and 64-bit
  • Windows only, 64-bit OS required. SQL Server Express and Web editions do not include SSIS
  • Azure Data Factory SSIS Integration Runtime
  • Self-hosted: credentials and data stay in your environment (external API calls still reach that service)
  • Fully functional 30-day trial of SSIS PowerPack

FAQ

Questions teams ask before they drop HTML Table Source on the canvas.

What is HTML Table Source?

A Data Flow source in SSIS PowerPack that scrapes data placed inside HTML TABLE tags from any URL or locally stored HTML file. Pick the table by number, CSS class or XPath, extract links and images from cells, and preview the result without running the package, all without coding.

Can I scrape several pages at once?

Yes. Enter multiple URLs or HTML file paths, one per line, or read them from an SSIS variable; the results are combined into one output. You can also parse a raw HTML string with TreatInputAsHtmlString.

Can it read tables built with div elements?

Yes. Use the ByXPathCustom extract method and set RowXPath (e.g. ./div[contains(@class,'row')]) and CellXPath (e.g. ./div[contains(@class,'cell')]) to define rows and cells.

How do I download files linked from a table?

Turn on OutputLinks to get a _Links column for each cell, then loop through the extracted links and download each file with the REST API Task. See read HTML table in SSIS and download links / images.

Which SQL Server versions can I run it on?

SQL Server 2025, 2022, 2019, 2017, 2016, 2014, and 2012 (32- and 64-bit), plus Azure Data Factory with an SSIS Integration Runtime (packages must target SQL Server 2017). See Compatibility and requirements.

Independent ratings

Trusted by data teams, recognized by the industry

See why teams trust ZappySys (opens in new tab)

What customers say

  • Customer story

    ZappySys has been a fantastic way to bring our small company into the world of APIs, automation, and systems integration by providing tools within an easy-to-use framework.

    Ben KingeryOxspring Paul
  • Customer story

    At Synchronous Customers, we need to connect various types of data quickly. The super handy ZappySys connectors and great documentation let us do it without writing a lot of code.

    Joel ConnerSynchronous Customers
  • Customer story

    I looked everywhere for a product that could integrate to a web portal backend API via JSON. After many attempts, ZappySys was the only solution that gave me all the options I needed in a quick & clean interface within SSIS.

    Maz DunicSave the Children Australia
  • Customer story

    We have worked with the ZappySys support team for over a year and have consistently found them extremely helpful — resourceful and creative in offering multiple solutions to our challenges.

    Senthil SekarPublicis Groupe
  • Trustpilot

    I’ve been using ZappySys for over 6 years — it makes development faster, and I introduced it to my current company.

    Anna JohnsonTrustpilot review
  • Trustpilot

    I’m integrating data from APIs into database tables with SSIS/ZappySys — very easy to use, fast, and highly efficient without writing complex code.

    Carolyn S.Trustpilot review
  • Customer quote

    I submitted a support request and had someone logged in and fixing things within 2 hours.

    Barry Wilson
  • Customer quote

    The REST source is very powerful — the only thing I found I could use after trying components from major vendors.

    Jes KirkupKTC
  • Customer quote

    Whenever we run into an obstacle, ZappySys has a solution for us. We are so glad that we chose ZappySys PowerPack.

    Kevin ChenBerricle

Start your free trial today

Install SSIS PowerPack and drag HTML Table Source onto the Data Flow.

Turn HTML tables on web pages into rows in your SSIS Data Flow, with no code.

  • Data Flow Source in SSISHTML Table Source appears in the toolbox after you install PowerPack.
  • Fully functional 30-day trialSSIS PowerPack, running in your environment.
  • Live supportHelp during your trial and after purchase.

New purchases may be eligible for refund review within 30 days. See the refund policy.

Talk to an engineer before or during your trial.

1 / 9