Who Uses This Software?

Microsoft Data Professionals who build data-centric applications and need high-performing SSIS components to access data from a variety of sources.

Average Ratings

37 reviews
  • Overall 4.5 / 5
  • Ease of Use 4.5 / 5
  • Customer Service 4.5 / 5
  • Features 4.5 / 5
  • Value for Money 4.5 / 5

Product Details

  • Starting Price $2154
  • Pricing Details $1,795 per license, per server plus $359/year required maintenance fee
  • Free Version No
  • Free Trial Yes, get a free trial
  • Deployment Installed - Windows
  • Training Live Online
    Webinars
    Documentation
  • Support Business Hours

Vendor Details

  • SentryOne
  • http://www.sqlsentry.net
  • Founded 2004

About Task Factory

Task Factory offers 60+ essential, high-performance components and tasks for SSIS that eliminate the need for programming

Spotlight_media_placeholder

Task Factory Features

  • Dashboard
  • ETL - Extract / Transfer / Load
  • Metadata Management
  • Multiple Data Sources
  • Web Services

Suggested Products

Task Factory Most Helpful Reviews

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

Translate with Google Reviewed on 11/2/2017
Jennyfer R.
Microsoft SQL Database Administrator / Developer
Construction, 1,001-5,000 Employees
Used the Software for: 1+ year
Reviewer Source 
Source: asdf
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

Comments: 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.

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

Translate with Google Reviewed on 8/31/2017
Jason B.
BI Developer
Information Technology & Services, 51-200 Employees
Used the Software for: 2+ years
Reviewer Source 
Source: asdf
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

Comments: 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

Vendor Response

by Pragmatic Works on 9/13/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.

Read More Reviews