Pragmatic Works

Task Factory

4.5 / 5 20 reviews

Who Uses This Software?

Microsoft Data Professionals who work with SQL Server Integration Services (SSIS)


Average Ratings

20 Reviews
  • 4.5 / 5
    Overall
  • 4.5 / 5
    Ease of Use
  • 5 / 5
    Customer Service

Product Details

  • Starting Price
    $1,495.00/one-time
  • Pricing Details
    Task Factory is licensed per server
  • Free Trial
    Yes
  • Deployment
    Cloud, SaaS, Web
  • Training
    Documentation
    In Person
  • Support
    Online
    Business Hours

Vendor Details

  • Pragmatic Works
  • pragmaticworks.com
  • Founded 2007
  • United States

About Task Factory

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


Task Factory Features

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

Task Factory Reviews Recently Reviewed!

F7fba6490e0351cc54e5261441669e9f

Awesome

Nov 16, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: I've always been on the fence on third party SSIS components, due to them not being built in Microsoft products, but the Upsert Destination is amazing, and the Advanced Cache Lookup components are crazy fast. I pump at least a trillion rows a day through them.

Cons: SCD was hard to understand, and support takes a little while to get back to you, so I ended up figuring it out on my own.

Overall: Massive speed improvement over built in Microsoft SSIS components.

2cae15de8862f6af3197d7e8ce655331

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

Nov 02, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

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.

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

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

Aug 31, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

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

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

Vendor Response

by Pragmatic Works on September 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.

Amazing set of components for any SQL & SSIS developer

Aug 18, 2017
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: The variety of components, set of tools for data warehousing development. Most of the SSIS tasks come with great deal of flexibility for configuration

Cons: Nothing not to like even though the learning curve can be a little steep. I wish the training piece was included as it is hard to convince bosses to spend extra on training

Overall: faster development, more flexibility in developing, amazing user community

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

Aug 15, 2017
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

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.

Overall: Am able to automate the loading of Salesforce Data

Versatile package of tools that's easy to use

Aug 15, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Ease of use, availability of videos and documentation, and great customer support. Many of the components are simple to drag and drop and configure to do what you need them to do.

Cons: It's a little clunky for the initial install. It is well documented, but still not as simple as a one step click.

Overall: sFTP, CRM connectivity, PGP, unzip.

Brings functionality of SSIS up to what it should be in the first place

Aug 15, 2017
4/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: Numerous components that are essential to using SSIS for data warehouse processing, in particular the Dimension Merge task and the various source/destination connectors

Cons: Fact Table delivery task is not yet flexible enough for deployment in our environment. User interface performance is occasionally sluggish.

We are using this tool quite successfully to supplement basic SSIS functionality.

Aug 11, 2017
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Love the different connectors. The REST connector is a game changer! The ability to simply and easily embed API calls within other related flows has been so beneficial.

Cons: Can't say "least" but I would love a direct connector for Google Analytics! Also, the REST api connector could use a little work around error handling.

Overall: Having BI professionals who may not have much experience with traditional coding languages being able to set up and take advantage of REST APIs. Saves me from hiring developers/contractors and improves our time to market.

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

Aug 10, 2017
4/5
Overall
3 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

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.

great features, easy to use

Aug 09, 2017
5/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Extremely easy to use Task Factory tasks that allows connectivity to cloud services, Azure, and SharePoint Great support!

Cons: There are no Task Factory task to facilitate connectivity to Active Directory. SharePoint task does not return all fields. Often I would have to use both the TF and the SP List Adaptor to get what I want.

Good SSIS components that will hopefully grow over time.

Aug 08, 2017
4/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: Works really well within SSIS. Takes the hassles out of most standard components and increases the ease of use.

Cons: There really should be more components. It is a bit light on functionality within some of the components, such as excel.

Task factory works as described, and has A LOT of documentation around it.

Aug 08, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Our primary use is interfacing with Salesforce.com. It allows us to upsert accounts, and bring tasks and events back out for use in SSAS.

Cons: Why isn't it a standard feature of SSIS. It feels so fundamental to organizations who have data sources in the cloud.

Overall: All the ones described on the sales brochure and more!
Seriously, solved all of our "How do we put it in Salesforce" problems

Great Tools! Great Support!

Aug 08, 2017
5/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: I love the support offered by the friendly staff. They are always quick to reply and quick to resolve.

Cons: More AWS tools would be nice, including items for Redshift, and also any REST API support, JSON parser, MongoDB, etc.

Task Factory components have simplified and accelerated my SSIS development time

Aug 08, 2017
4/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money

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.

Task factory has greatly improved our productivity, we no longer need to write/maintain custom code

Aug 08, 2017
4/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money

Pros: Ease of use, even our staff who are relatively new to SSIS find it easy to use and are able to start creating packages in a short period of time.

Cons: There are a few task that don't have complete documentation, for example the 'Secure FTP site' is missing documentation for the new 'Get List of Files with Metadata' action.

Vendor Response

by Pragmatic Works on September 14, 2017

Thank you for the feedback, and we are glad to hear you are finding it beneficial. We have added a work item to update the documentation that you mentioned. If you have other items like this, you can email them to support@pragmaticworks.com or submit them at pragmaticworks.uservoice.com, and we will be happy to address them.

Great addition to the toolbox of SSIS developer

Aug 08, 2017
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: variety of SSIS tasks that compliment our of the box SSIS tasks, great set of tasks for data warehousing that save tens of hour each week

Cons: nothing so far, the learning curve is a little unless you are willing to pay for the full training set.

Overall: major time savings, adding capabilities that we did not have before and had to use script tasks etc. to get around the requirements

Best integration tool to connect to Salesforce and SSIS

Aug 08, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Easy to install the software. Easy to integrate using visual studio and connect with salesforce application.

Cons: At this moment we have not identified any negative impacts by using the taskfactory software for our specific integration purpose.

Overall: Easy integration from the development standpoint and from the functional standpoint. Client is thoroughly satisfied with this product. We have not come across any issues since implementation.

Task Factory is a great set of tools that require little training to get up and running.

Aug 08, 2017
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Diversity in the data you can access with the controls. The value factor is excellent. I like the idea that I don't have to keep up with all the latest changes for every interface/API I use.

Cons: Some of the controls were not available for older versions of Microsoft SQL Server (Rest). The speed of some of the controls were a little on the slow side.

Great addon that saves a ton of time for us

Aug 08, 2017
4/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money

Pros: This saves TONS of time for us on our SSIS operations using TF Upsert Destination. It handles updates to databases without worry about duplicate row being added by mistake.

Cons: You had to read the help files to fully understand what you were doing. There are so many widgets in the package we bought, it was hard to know what we needed to use.

Really makes Task easy

Aug 08, 2017
5/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: I really like the ease from which I can use the Salesforce connectors. The UI that I get and other features within the connectors makes the task very easy to pull the data from salesforce. Another feature that I like is the Upsert destination which has made the insert or update destination such an easy process. The Interface for each of this connectors are super easy to understand

Cons: I would like some more features added to the troubleshooting and detailed logs on some of the components.

Overall: Salesforce connectors, FTP component, Upsert Destination, etc