Task Factory: SSIS Components That Save You Time and Money 


 Free Trial       Buy

Bogged down with building SSIS packages?


Developer teams building data-centric applications on the Microsoft data platform face challenges when using SQL Server Integration Services (SSIS) for data extract, load, and processing (ETL) tasks. Ensuring an efficient ETL design is one of the most important—but often overlooked—aspects of ensuring a high-performing data-centric application. 

If your SSIS packages aren't performing efficiently, you're potentially wasting development resources, processing power, and hardware resources. Without the right tools, your team could be facing:

  • Excessive development time spent programming custom SSIS tasks

  • SSIS components and tasks that aren’t optimized to perform well in production

  • Difficulties connecting to a broad array of data platforms

  • Difficulties loading and managing the data warehouse, and in maintaining SSIS packages

  • Slower resolution of production problems

 

Inefficient SSIS performance costs your business in strained development time and resources, wasted processing power, and slow application performance.

Task Factory saves time in building high-performance SSIS packages 

 

Task Factory is a set of 75+ high-performance SSIS components that are built to accelerate ETL processes. Task Factory simplifies component loading and data warehouse management. With Task Factory, you can connect to nearly any data source, which saves development time, especially when you're working with data warehouse scenarios with multiple disparate data sources. 


Task Factory is constantly updated so you can be sure that the SSIS components are optimized for compatibility with the latest version of SQL Server. And Task Factory can be used with Microsoft developers’ native environment—Visual Studio.

 

Explore how Task Factory saves time in building high-performing database apps

Task Factory Connectivity

Connect to multiple data sources

Connect to dozens of different data sources from platforms such as Hadoop, SharePoint, Salesforce, Facebook, Twitter, and virtually any REST-enabled source—without writing any code.

Learn More

Increase productivity

Development teams often face trade-offs between programming efficiency and application performance. With Task Factory, you can both eliminate needless programming of SSIS components and improve the efficiency of your data-centric applications in production. Productivity components include Secure FTP Task, data cleansing components such as the Null Handler, and more.

Learn More

Task Factory Productivity
Laptop-Images_SSIS-Advanced-HTML-SMS-Email-TaskUI

Improve performance

Accelerate performance of your data-centric applications with Task Factory high-performance components, including the Upsert Destination (which speeds batch processing), and the Dimension Merge SCD, which is a high-performance replacement for the Slow Changing Dimension wizard in SSIS.

Learn More

Managing and loading data warehouses

Accelerate the process of loading and managing data warehouses with Task Factory components like Dimension Merge SCD Transform, which helps you load a slowly changing dimension in SSIS much faster than with built-in components. Task Factory streamlines many tedious data warehousing management tasks, including upserting data.

Learn More

Laptop-Images_DimensionMergeSCDStep13 (1)
Azure Data Factory

Run SSIS packages in the cloud

With Task Factory Azure Data Factory edition, you can run SSIS packages on Azure, so you can take advantage of existing data processes. Azure Data Factory edition allows you to pull data from and load cloud data sources just as you would with an on-premises data source.

Learn More

Task Factory Pricing Options

 

Compare Editions

 

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

75+ SSIS tasks and components

 
Buy

Azure Data Factory

$1,495 

Per ADF Node

 

Subscription Only

Total Price

$1,495




 
Buy

Frequently Asked Questions

 

How is Task Factory licensed?

Task Factory is licensed per server instance. There is no license necessary to use Task Factory in the Integration Services development environment (Visual Studio, SQL Server Data Tools, or Business Intelligence Developer Studio). Please contact sales@sentryone.com for more information.

Does Task Factory support Salesforce TLS 1.2?

Yes, but in order to continue using the Salesforce features, you must upgrade to the latest version of Task Factory. Click here for more information on Salesforce's upgrade to TLS 1.2.

What are the system requirements for Task Factory?

  • SQL Server Integration Services 2008, 2012, 2014, 2016 or 2017
  • BIDS 2005 or 2008 (Business Intelligence Development Studio) or SQL Server Data Tools 2012, 2014, or 2016 (for Visual Studio 2015 and 2017)
  • Windows XP or later
  • Windows Server 2000 or later

What functions are available with Task Factory?

There are a number of functions available with Task Factory. Click here to view a complete list.

Can Task Factory be used with Azure?

Yes, Task Factory components can be used with Azure databases.

 

View All FAQs