About Task Factory

Task Factory is an on-premise and cloud-based data integration tool, which offers various SQL Server Integration Services (SSIS) components for businesses to enhance data warehouse management and extract, transform, load (ETL) processes. The File Gateway Source enables professionals to verify text files by separating valid/invalid rows and creating rules.

Task Factory allows organizations to encrypt, decrypt, sign, verify, compress and decompress sent or received files. The SSIS Email Source Adapter filters emails based on sender, date, body, subject and priority, among other elements. Additionally, the Excel Source helps professionals connect with existing files and extract data according to requirements.

Task Factory lets businesses extract data and con...


Read More

Supported Operating System(s):

37 Reviews of Task Factory

Average User Ratings

Overall

4.57 / 5 stars

Ease-of-use

4.5

Value for money

4.5

Customer support

4.5

Functionality

4.5

Ratings Snapshot

5 stars

(21)

21

4 stars

(16)

16

3 stars

(0)

0

2 stars

(0)

0

1 stars

(0)

0

Likelihood to Recommend

Not likely

Very likely

Showing 1 - 5 of 37 results

November 2017

User Profile Picture

Jennyfer from Sundt Construction

Verified Reviewer

Company Size: 1,001-5,000 employees

Industry: Construction

Time Used: Less than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

November 2017

I frequently use Task Factory in the SSIS package I create for integration between system.

I am able to solve problems in a single SSIS package vs using SSIS and Linux scripts.

Pros

Task Factory really expands the types of tasks that are available in SSIS. We have used Secure FTP Task, PGP task, and Advanced Email to accomplish complex scenarios that we had to use custom scripts to accomplish before. This is helping us reduce our footprint because we are phasing out a Linux server we have that used to encrypt and move files back and forth between secure FTP sites. We are able to replace everything this Linux server was doing with script with a single SSIS package thanks to the Task Factory tasks. I especially like the "TF Error Output Description" and have used it many times in troubleshoot failures. I don't know what I did before this feature! There are so many more features that Task Factory has that I'm excited to explore. When I have a problem I'm trying to solve in SSIS, my new attitude is "I bet Task Factory can do that!"

Cons

Sometimes I have trouble finding which feature will accomplish what I need. For example, I needed to have a unique number generated for each row in a flow but use the last number as the new starting number. After some investigation I found that I can easily accomplish that with the "Surrogate Key Transform" it just took me a while to figure out that was the task I needed.

August 2017

Jason from Grey Matter Ltd

Company Size: 51-200 employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

August 2017

As a heavy user of SSIS I have found Task Factory to be an essential add-on.

Enables me to implement a work load that would of taken much longer or required more developers.

Pros

Massively reduces development time. Reduces complexity of package design thus making packages easier to maintain. Replaces many script tasks jobs for which you would have to write substantial code. My favourite components are the Update/Upsert Tasks as they remove the need for writing a lot of SQL plumbing code.

Cons

None

Response from Pragmatic Works

Replied September 2017

Thank you for the feedback, Jason. We really appreciate it. On the item you mention on Visual Studio upgrades, please note that the Visual Studio SSIS toolbox doesn't read it's information from the GAC, it uses folders under [YourSQLServerInstallFolder]\[version]\DTS. The Task Factory installer installs into this folder if it exists, but if you upgrade the version of SSIS installed, you need to reinstall TF afterward to ensure it puts the components in the newly created SSIS folders.

August 2017

Floris Jan from KNS Automatisering

Company Size: 11-50 employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

3.0

Value for money

4.0

Customer support

4.0

Functionality

5.0

August 2017

With Task Factory we implemented the integration with Salesforce and other systems quick and easy.

Pros

The software is easy to use and has a lot of features. When creating SSIS flows, sometimes I am surprised to learn about a feature I didn't use before.

Cons

Sometimes the software 'thinks' a little bit too much. Changes in upstream columns trigger the automatic column matching process. Sometimes this breaks existing functionality.

August 2017

Jason from NeuAnalytics

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

4.0

Customer support

5.0

Functionality

4.0

August 2017

Task Factory components have simplified and accelerated my SSIS development time

Pros

the components provide easier solutions for what I used to have to build based off the out of the box SSIS components or in a Script Task. The #1 benefit of Task Factory is time savings. I started using Task Factory about 7 years ago when it was version 1.x and they are of such value that I would not work for a company as an SSIS developer if they would not purchase BIxPress and Task Factory.

Cons

I have always been frustrated by the minimalist documentation for the components. This applies to all Pragmatic Works software actually. There are either no real world examples or just one. This is unfortunate because the Task Factory components are usually pretty powerful and feature rich. The documentation is usually along the lines of telling you what each tab or check box or drop down list in the component does but rarely how that component would fit into a larger data flow or control flow to accomplish a common business need. As much as I love Pragmatic Works I would say this is the #1 room for improvement.

August 2017

Michael from Centurylink

Company Size: 10,000+ employees

Industry: Telecommunications

Time Used: Less than 12 months

Review Source: Capterra


Ease-of-use

4.0

Value for money

4.0

Customer support

5.0

Functionality

4.0

August 2017

It gets the data I need from Salesforce. One of my peers is using it to do Secure FTP.

Am able to automate the loading of Salesforce Data

Pros

It works. I get the data I need using tools I am familiar with. Great Customer Service. The Secure FTP option did not work in the first version we installed. There was a patch released which fixed the problem. Once we installed the upgrade, everything worked as expected.

Cons

Not necessarily a problem with Task Factory, more a problem with SSIS. SQL Server converts certain fields to Boolean or Bit. These are not valid in Oracle. Also, using CHAR instead of VARCHAR is undesirable. We are an Oracle shop so this can be frustrating. SSIS data convert is not friendly so doing a conversion on a table with 600 columns requires too much effort. Some of the fields can be adjusted in the advanced editor but it sometimes forgets the settings if changes are made. Easiest method is to load data into a SQL Server table and then use CAST statements to convert the data for Oracle. A little bit of workaround but it can be done.