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.

Task Factory is a set of 75+ high-performance SSIS components that save you time and money by accelerating ETL processes and eliminating many tedious SSIS programming tasks.

Get Started with Task Factory

Task Factory Buying Options

Learn More

Try Task Factory for Free

Download Free Trial

Fact Table Destination

 

Task Factory 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 Pricing Options

 

Contains 75+ 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

Contact us for subscription pricing.

Buy

Pro

$2,495

Per Server

+

$499

for the first year of annual maintenance

$2,994

due at checkout

75+ SSIS tasks and components

Contact us for subscription pricing.

Buy

Task Factory Modules

$425–$795

Per Server
Annual Subscription Only

 

Choose from more than a dozen Task Factory modules, each of which delivers high-performance components targeted to a specific SQL Server Integration Services (SSIS) task. 

Learn More