Task Factory Modules

 

Address specific SSIS tasks with Task Factory modules

Task Factory provides 70+ high-performing SSIS components that help you connect to nearly any data source, increase productivity, improve the performance of your data-centric applications, and load and manage your data warehouse. Learn more about Task Factory.

If you need just a few components to address a specific challenge in your ETL pipeline, we've got you covered. Choose from 13 Task Factory modules, each of which delivers components targeted to an SSIS task or data source.

 

Task Factory Module Components Included Price Per Server
Annual Subscription Only
Purchase Module

Address Validation
Parse unformatted address data, transform it into USPS standardized address data, and verify United States addresses are correct with the USPS database.

(Requires a USPS database subscription for verification.)

  • Address Parse Transform
  • USPS Address Verification Transform
$425 Buy
Advanced Storage
Simplify file processing and send files to and retrieve files from connected systems.
  • HTTP Download File Task
  • Secure FTP Connection Manager and Task
  • File Compression Task
  • PGP Encryption Task
  • File Properties Task
  • Azure REST Source, Destination, and Connection
  • AWS S3 REST Source, Destination, and Connection
  • Google Drive REST Source, Destination, and Connection
  • Google Cloud REST Source, Destination, and Connection
$495 Buy
Big Data & Analytics
Retrieve data from and send data to blob storage on Azure for an ML web service.
  • Azure ML Batch Execution Task
  • Azure ML Storage Source and Destination
  • Azure Storage Connection Manager
$795 Buy
Data Warehousing
Clean, manipulate, and process large data loads.
  • Delete Batch Transform
  • Time Zone Conversion Transform
  • Update Batch Transform
  • Upsert Destination
  • Oracle Upsert Destination
  • Data Cleansing Transform
  • Dimension Merge SCD Transform
  • Fact Table Destination
  • Surrogate Key Transform
$795 Buy
Dynamics
Send data to and receive data from Microsoft Dynamics.
  • Microsoft Dynamics CRM Source and Destination
  • Dynamics CRM Connection Manager
  • Dynamics CRM OData Connection Manager
$795 Buy

Email
Send, receive, move, and delete email, and filter data coming in from a mailbox, as part of your ETL process.

  • Advanced Email and SMS Task
  • Email Source and Connection Manager
  • Delete or Move Email Source Message Task
$425 Buy
Enhanced ETL
Eliminate tedious SSIS programming tasks, such as removing nulls, extracting data via regular expression, and extending conditional split functionality.
  • Advanced Aggregator Transform
  • Advanced Conditional Split Transform
  • Advanced Derived Column Transform
  • Advanced Execute Package Task
  • Advanced Execute Process Task
  • Advanced Lookup Transform
  • Advanced Lookup Cache Connection Manager
  • Advanced Lookup Cache Transform
  • Regex Replace Transform
  • Replace Unwanted Characters Transform
  • Trim Plus Transform
  • Null Handler Transform
  • Case Transform
  • File Gateway Source
  • File Gateway Task
  • Hash Transform
  • Expression Task
  • Filter Rows Transform
  • Error Output Description Transform
  • Timer Task
$795 Buy
Excel
Read data from and write data to Microsoft Excel, and refresh Excel files with Power Query connections and Power Pivot tables.
  • Excel Source, Destination, and Connection Manager
  • Excel Power Refresh Task
$425 Buy
REST
Extract data from and write data to web or internal REST sources.
  • REST Source, Destination, and Connection Manager
  • REST OAuth Connection Manager
  • REST OAuth2 Connection Manager
  • Pack Data Transform
  • Unpack Data Transform
$795 Buy
Salesforce
Pull data from and send data to Salesforce.
  • Salesforce Source, Destination, and Connection Manager
$795 Buy
SharePoint
Retrieve data from and send data to a SharePoint object in an SSIS package, and upload and download documents from a SharePoint documents list in SSIS.
  • SharePoint Source, Destination, and Connection Manager
  • SharePoint Documents Connection Manager and Task
$425 Buy
Social
Extract data from social media sources, such as Twitter and Facebook, for use in SSIS packages.
  • Social OAuth Connection Manager
  • Twitter Source
  • Facebook Source
  • Pack Data Transform
  • Unpack Data Transform
$425 Buy
Structured Document
Create and parse JSON, XML, and delimited data, and generate, write, and export XML.
  • Pack Data Transform
  • XML Destination
  • XML Output Destination
  • XML Generator Transform
  • Unpack Data Transform
$495 Buy

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 Modules

Annual Subscription License

 

$425–$795

Per Server


Learn More

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

Task Factory

Annual Subscription License

 

$1,245

Per Server
Includes annual maintenance

Buy

70+ SSIS tasks and components

Task Factory Azure Data Factory

Annual Subscription License

 

$1,495 

Per ADF Node

 
Buy

65+ SSIS tasks and components