Task Factory
"I have found Task Factory to be a huge time saver with SSIS development. The SalesForce components alone saved close to two months of work on a major integration project. I highly recommend!"
Alan Rubel
Database Administrator
Joint Commission Resources
Task Factory Loews Corporation
"We bought the product mostly because of the company's reputation for the service they provide and the specific need of a secure SFTP task."

Matt Cushing

Application Systems Analyst/Developer

Loews Corporation

Greater New York City Area

Task Factory - Mark Marinovic
"We bought Task Factory primarily for the SCD Type 2 task, as it enabled us to do several things the built-in SSIS SCD task did not do. Task Factory comes highly recommended from me as our ROI was reached in just days."

Mark Marinovic

Task Factory - Jay Cole
"I purchase Task Factory over a year ago, and let me tell you, IT WORKS FLAWLESSLY. I haven’t had a single problem with it, and I used to HATE having to make changes with the version you’re using. My advice (for what it’s worth) is to pay the money!"

Jay Cole

Task Factory - Urban Outfitters
"We have found that Task Factory tremendously speeds up the development process and improves performance by means of the high-performance components."

Tim Harris

BI Data Engineer

Urban Outfitters Inc.

Task Factory logo
Price starting at
$1495
Buy Now Free Trial Download Beta Download Compare Editions

Task Factory

 Dozens of new SSIS components for your toolbox.
  • Performance - Increase SSIS performance up to 90%
  • Productivity  - Faster and reusable SSIS development
  • Data Quality  - Garbage in, gold out of your data
  • Security  - Trust that your data is encrypted and transmitted securely
  • Connectivity - Connect to cloud and non-traditional data sources not available in ODBC or OLE DB

Task Factory offers essential, high-performance components and tasks for SSIS that eliminate the need for programming. Using Task Factory can increase productivity, give you a much higher level of performance and provide you with an incredibly high ROI. The investment in Task Factory will undoubtedly save you or your dev team thousands or ten of thousands of dollars in saved development time. Try Free for 14 days. With 30+ features, our SSIS Tool is sure to deliver! To find answers to common questions, please visit our Product FAQs page.

New Features
This product is now compatible with SQL Server 2014.
Read More
The Oracle Upsert Destination will allow users to easily insert and update data into an Oracle table within their SSIS package.
Read More
The SharePoint documents task will give users the ability to upload or download documents to or from a document library in a SharePoint server.
Read More
The time zone conversion transform will convert the value of a target column from one time zone to another and place it into a new column.
Read More
Helps synchronize two systems no matter the source or destination. Many companies struggle with the development of loading procedures that determine whether the row is new or to be updated. The Upsert Destination reads the rows coming into the data flow and detects if the row should be inserted or updated. This saves the developer a long development cycle and could save up to 90% on each execution of a package.
Read More
Data Quality
The Case Transform provides a way to properly case, uppercase or lowercase all the text in a source column.  There is a single action which is “Convert string to Proper case” but there are many styles in which the data can be properly cased data.
Read More
The TrimPlus Transform provides a way for users to trim either whitespace or user defined characters from the beginning and end of source columns.
Read More
The RegEx Replace Transform allows the user to define a regular expression to either replace (with user defined value) or extract data from a source column.
Read More
The Null Handler Transform allows the user to replace null or blank values from their source data with a user defined value (e.g. replace null with empty string or vice versa).
Read More
The Replace Unwanted Characters Transform allows the user to remove unwanted characters or words from source data.
Read More
The Data Cleansing Transform has 16 built in algorithms that allow you to clean data without any programming or SQL updates.  This feature is used to cleanse data from a source by applying cleansing rules to the data.
Read More
Acts as a gatekeeper for your data. Many companies receive questionable data from various sources, causing a myriad of production problems and inconsistent reporting. The Data Validation Transform verifies that your data is clean prior to insertion. Rows that are suspicious are flagged for later removal or additional business rules.
Read More
Address data elements include AddressLine1, AddressLine1, City, State, PostalCode, StreetNumber, StreetDirection and much more.
Read More
Performance
The Update Batch Transform allows you to easily update data in a table without writing any SQL statements and then continue on with the other tasks in the data flow.
Read More
The Delete Batch Transform allows you to easily delete data in a table without writing any SQL statements and then continue on with the other tasks in the data flow.
Read More
Helps synchronize two systems no matter the source or destination. Many companies struggle with the development of loading procedures that determine whether the row is new or to be updated. The Upsert Destination reads the rows coming into the data flow and detects if the row should be inserted or updated. This saves the developer a long development cycle and could save up to 90% on each execution of a package.
Read More
Designed to handle most of the dimension loading scenarios (as per Kimball Method) in few clicks.
Read More
Productivity
The XML Generator Transform gives SSIS developers the ability to map XML Schemas (XSD’s) to columns from one or more source inputs to generate complex XML documents.
Read More
The Data Flow Nugget Transform brings the ability to setup a single package for with business or data rules that can be reused across several packages. When using the Data Flow Nugget Transform you have the ability to change the business rules one time instead of changing the rules in every SSIS package that use the same rules.
Read More
The Download File task is used for downloading files with the HTTP protocol.
Read More
The Advanced Execute Process Task provides a way for you to execute commands as if you were using the command line utility in windows.
Read More
The Advanced Execute Package Task provides a way for you to execute a child package from your SSIS package as well as passing and retrieving variables to and from the child package.
Read More
The Error Output Description Transform allows the user to connect error outputs to it from sources and transforms and get descriptions on why the particular row failed. Normally the user is unable to see the data that caused a failure but with the error output description the user can see not only the exact error but the row data that caused the error.
Read More
This free component allows you to quickly add a destination to your package without any configuration.  This is useful when developing your SSIS packages and you want to quickly add a destination without having to configure a flat file destination or any other destination that will eventually be detected. 
Read More
Sends emails from within an SSIS package through SMTP.
Read More
Adds an identifier column to a data flow used to uniquely identify a row.
Read More
Reads the properties of any file and stores property in variable. Many companies receive large data files from outside their organizations and run the risk of loading the file prematurely during transmission causing an SSIS failure. Our File Properties Task gives you the power to eliminate this problem by determining if the file is in use or transmitted before loading. The File Properties Task additionally saves drive space by identifying old files ready for archive.
Read More
Compresses or decompresses a file or directory. Many companies struggle with transmitting files larger than 1 GB. Our Compression Task will compress files within SSIS by up to 90%, allowing greater speed and less network space.
Read More
Designed to handle most of the dimension loading scenarios (as per Kimball Method) in few clicks.
Read More
The Expression Task allows you to take full advantage of the 180+ functions in our Expression Engine to set variables, call stand alone functions like CreateFile without any scripting.
Read More
Our Advanced Lookup Transform supports all the functionality of the native lookup but allows for easier use of range lookups as well as supporting non-equality lookups without writing a query. One of the biggest features of our Expression Engine is the use of Disconnected Lookups. With disconnected lookups, you can create a cache and then use that cache across multiple component instances. For instance, you can cache the product table once and then while using an Advanced Conditional Split, lookup the Product Name from the Cache without being connected to the lookup.
Read More
Our Filter Rows Transform allows you to filter rows based on an expression. This is similar to a conditional split, but now only the rows that match the filter will be sent through to the dataflow and the rows that don’t match are filtered out.
Read More
Our Advanced Aggregator Transform takes aggregation in SSIS to the next level. We extended the base functionality of aggregate functions to allow expression based aggregation and added a few more aggregation functions (First, Last) into the equation. So now you can use something like SUM(Quantity, UnitPrice > 20) which will only sum the quantity if the price is greater than 20.
Read More
The Advanced Conditional Split extends and replaces the native SSIS Conditional Split to allow you to use our expanded Expression Engine and its 180+ functions to create conditional splits in your dataflow.
Read More
The Advanced Derived Column extends and replaces the native SSIS Derived Column to allow the user to use our expanded Expression Engine and its 180+ functions to create new columns in your dataflow.
Read More
Connectivity
The Dynamics CRM Source will allow users to retrieve data from a Dynamics CRM Server within their SSIS package.
Read More
The Dynamics CRM Destination will allow users to Insert, Update, Upsert and Delete data from a Dynamics CRM Server within their SSIS package.
Read More
Reads email from a mailbox into a data flow.
Read More
The XML Destination allows the user to export source data to an XML File.
Read More
The SharePoint List Destination Adapter allows users to quickly connect to their SSIS packages to SharePoint servers to send data to lists.
Read More
The SharePoint List Source Adapter allows users to quickly connect to their SSIS packages to SharePoint servers to retrieve list and view data.
Read More
With this component you will be able to very easily add data from your system into your salesforce.com account with very little configuration.
Read More
Easily retrieve the data stored in your salesforce.com account with a few simple clicks.
Read More
Security
The PGP Task brings easy to use PGP encryption, decryption, file signing and verification to SSIS that is based on OpenPGP. technology.
Read More
Brings encrypted security to FTP within SSIS. Many companies transmit files using FTP as a transmission method for highly sensitive files. The Task Factory Secure FTP Task will allow you to transmit files over most common secure channels to your partners safely.
Read More
Some Of Our Clients
Copyright 2014 by Pragmatic Works