Feature_Part_of-Product_Logos_Task_Factory (1)

 

Task Factory Feature: Excel Source and Destination

 

FREE TRIAL
BUY

The Excel Source and Destination works in 64-bit machines and easily reads metadata. The Power BI Refresh task can also refresh your Excel Power BI queries and data.

HELPFUL LINKS

Help Documentation

Data Sheet

 

Please reach out to us for more information or a personalized demo.

+1 (704) 895-6241

 

FREE TRIAL

Excel SSIS Source

 

Task Factory 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 reads data out of Excel even when running on 64-bit machines. 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 many times, 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
Task Factory Excel SSIS Destination

Excel Power BI Refresh SSIS Destination

 

Task Factory Excel Power BI Refresh SSIS Destination

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 Buying Options

 

Contains 60+ tasks, connection managers, sources and Destinations for SSIS. You can compare editions here. Task Factory does not require a license while you're running packages in Visual Studio.

 

Standard

$1,795

Per Server

+

$359

for the first year of annual maintenance

$2,154

due at checkout

30+ SSIS tasks and components

BUY

Pro

$2,495

Per Server

+

$499

for the first year of annual maintenance

$2,994

due at checkout

60+ SSIS tasks and components

BUY