Task Factory Feature: Fact Table Destination SSIS Component 

Fact Table Destination

The Fact Table Destination loads data warehouse fact tables in a fraction of the time and with much less development work.

SolarWinds Task Factory provides dozens of high-performance SSIS components 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

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
 

Fact Table Destination

 

tf-fact-table-destination

Fact Table Destination can greatly reduce development time for SSIS packages with multiple dimension lookups. With the Fact Table Destination, developers can now perform these lookups and insert data into a fact table within a single UI.

Additionally, users can choose between insert and update actions for the fact table, configure table join conditions to dimension tables from their source data, create column aliases for multiple lookups on the same dimension, and define a default value to prevent NULLS from being added. Advanced features like ranged lookups are also supported. Save hours off your fact table load with this batch process.

Feature Highlights

  • Load a fact table using SSIS in a fraction of the time
  • Perform ranged lookups during the load to reload historical data
  • Reduction in development time
  • Performs surrogate key lookups in bulk

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

$1,245

Per server
 

65+ SSIS tasks and components

Task Factory
Azure Data Factory

Annual Subscription License

$1,495 

Per ADF node
 
 65+ SSIS tasks and components