Task Factory Feature: Excel SSIS Components 

Excel SSIS Components

The SolarWinds Task Factory Excel Source and Destination SSIS components read data from and write data to Excel. They can run on 64-bit machines and easily read metadata.

The Task Factory Power BI Refresh task refreshes your Excel Power BI queries and data.

Task Factory provides dozens of high-performance SSIS components, including Excel connectors, that save you time and money by accelerating ETL processes and eliminating many tedious SSIS programming tasks.


Download Free Trial

Learn More About Task Factory Pricing

Task Factory Excel Module

Includes 4 Excel-specific components. Learn More

Task Factory

Includes 60+ high-performing SSIS components that help you efficiently manage ETL pipelines. Learn More


Task Factory Azure Data Factory 

Includes 65+ high-performing SSIS components that help you efficiently manage ETL pipelines in Azure Data Factory (ADF). Learn More

Excel SSIS Source



Reading data out of Excel can be a pain! The native Excel Source built into SSIS often has issues retrieving data on a 64-bit machine and can read the wrong data types from Excel.

The Excel Source in Task Factory solves for that.  It can read ranged data and gives you an easy to use preview to ensure you have the right amount of data. Most importantly, it reads data out of a spreadsheet with the right data type.

Feature Highlights

  • Reads data out of an Excel file on 64-bit machines
  • Can read from data ranges
  • Formats the data with the proper data types as data is read out

Excel SSIS Destination


Loading data into Excel can be a painful task. It's hard to control the formatting, and, often, things don't work on modern day machines in 64-bit.

The Excel Destination works natively with 64-bit machines while writing in data with the proper data types. As the destination is writing data, it can append or overwrite the existing data. It can also create an Excel table with more stylized data.

Feature Highlights

  • Loads data into an Excel spreadsheet in 64-bit mode
  • Specify the format of the data
  • Insert, append, or replace data

Excel Power BI Refresh Task



The Excel Power BI Refresh Task is a control flow component that refreshes an Excel file with Power Query connections and Power Pivot tables. It's especially useful if you have Excel files on a shared drive that you want to refresh regularly without having to purchase SharePoint.

Feature Highlights

  • Refreshes the data in Excel files with Power Query connections
  • Refreshes the data in Pivot Tables

Task Factory Licensing Options

A Task Factory license is not required to use Task Factory when developing and running packages in Visual Studio/SSDT. However, a Task Factory license is required to use Task Factory for packages run outside of Visual Studio/SSDT.

Compare Editions

Task Factory

Annual Subscription License


Per server

65+ SSIS tasks and components

Task Factory
Azure Data Factory

Annual Subscription License


Per ADF node
 65+ SSIS tasks and components