Task Factory Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
47 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.9 out of 100

Do you work for this company? Manage this listing

TrustRadius Top Rated for 2019

Overall Rating

Reviewer's Company Size

Last Updated

By Topic




Job Type


Reviews (1-25 of 31)

John Stuchly | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
We have been using Task Factory to better standardize our ETL and to reduce the number of script tasks leveraged. It is primarily used for data flow and control flow tasks, although some connections are used as well. This is used as a standard, centralized tool within IT, along with other 3rd party SSIS tools.
  • Email notifications.
  • File management.
  • User defined settings for external package calls.
  • Better software update methodology.
Being able to easily call packages from other projects is the biggest win. Having a single process to handle all child calls is a big win over using the standard component for calls within a project, and some other mechanism (via SQL stored procedure calls and/or SQL agent calls) for packages not within the same project.
Read John Stuchly's full review
John C Hill | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Task Factory is used in the IT department only. It addresses the need for data connections and transformations that are not included in the base SQL Server Integrations Services system.
  • Tasks are more automated than having to create them by hand.
  • Support is great either in forum settings or direct contact with support.
  • Maybe ensuring that all assemblies are deleted when having to install Task Factory on the server.
For the tasks available in Task Factory, it does them very well. The upsert task is ideal for my uses. I do wish that there was some sort of delete or mark as delete feature when loading data into a data warehouse. We don't run Enterprise Edition of SQL Server so we don't have the change data capture feature.
Read John C Hill's full review
Jason Loy | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
I am testing Task Factory features and functionality to determine if it's a good fit for our organization. It is currently not widely implemented across the business, but there is potential for it if the POC proves viable. I am primarily looking at Task Factory to replace cumbersome, manual API calls and to streamline data flow from 3rd parties into our internal data warehouses.
  • Good SSIS integration with other packages and processes.
  • Easy to configure 3rd party account logins, credentials, etc.
  • Intuitive interfaces.
  • The user-experience could be a little more intuitive. Struggled a bit to put all the pieces together the right way in order to get the data processed the way I needed.
Task Factory seems like it would be great for moving data out of our third-party systems and into our own data warehouse where it can be combined with our other mission-critical data. We are really seeking a way in which we can merge our users' front-end behavior and actions with back-end outcomes. Task Factory seems suited to the task.
Read Jason Loy's full review
Brett Archer | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
The main reason we purchased Task Factory was to decrease the time to do Upserts into SQL Server and Oracle databases. Without it, developers would manually have to do lookups/inserts/updates in SSIS.

Although this was the main reason for the purchase, there are so many other components we use in SSIS like the termination task, the Sharepoint task, and the email task. Some of these tasks seem like "no brainers" that should be in SSIS by default!
  • Upserts to Oracle and SQL Server
  • Email
  • Secure FTP
  • Cleaning up DB objects when Upserts fail
Well suited for upserts. However, there are some limitations based upon primary keys, column names, etc. Sometimes if you package crashes or fails, Task Factory doesn't clean the temporary objects in the database.
Read Brett Archer's full review
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Usage: We are using Task Factory inside the IT department to enhance the capabilities of SSIS (SQL Server Integration services).

Business problem: Your team can keep using SSIS and tackle data problems they could not resolve before (read from different sources without any code and do data upsert in one component).
  • Read from APIs without code.
  • Upset mechanism.
  • Can be longer to debug.
  • Need one license for dev servers.
Well suited:
  • When the capabilities of SQL Server Integration Services (SSIS) are not enough for you.
  • When you want to extract data from web sources without writing some code.
Not Well suited:
  • If you have separate servers for all your environments (that will cost you more money).
  • If your team does not know SSIS enough (the tool can be difficult to debug).
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Used and implemented by my team , serving company needs . Connecting to REST API.
  • Rest API
  • FIle properties
  • Secure FTP task
  • Upsert
  • Amazon Connectors
  • S3 Connectors
  • Red Shift Connectors
  • Tableau Connectors
Data source calls where SSIS has limitations task factory can work well but there are company's outside has all the connectors. So, Task Factory has to improve its list of items.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Our Business and Application Reporting team is using this tool. We are using this to take the data from our Salesforce org into a data warehouse. Once the data is there we use it to create Microsoft Power BI reports. Also we use Task Factory to upsert data into Salesforce for any data migration projects. This has solved a numerous amount of issues regarding moving Salesforce data in and out of our data warehouse and other ETL.
  • Upsert Salesforce data.
  • It is simple to use.
  • Very straightforward upgrade process.
  • Continually getting new features that are useful.
  • More drag and drop interfacing.
  • Modernize the UI.
Works great for Salesforce. I can take any flat file or other source and upsert to Salesforce. I think the other way around is also well done. I would like to see a better way to create the relationship between records, but otherwise well done. It has always finished the tasks we need it to.
Read this authenticated review
Anonymous | TrustRadius Reviewer
October 25, 2019

Task Factory Review

Score 8 out of 10
Vetted Review
Verified User
Review Source
It was initially used to upload and download data from Salesforce. It was then used as part of our ETL to load data for Analysis Services models, both MOLAP and Tabular.
  • Connect and access data in Salesforce
  • Slowly changing dimensions task
  • Error codes and descriptions
  • I haven't used enough in recent months to suggest improvements.
On-premise SQL Server running integration packages. I have not tried to use Task Factory with the intergration packages in Azure.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Purchased for Salesforce connectivity from our SQL Server platform. We have since leveraged other features such as Upsert.
It is used in support of our organization-wide data warehouse.
  • Upsert - simplifies coding.
  • Facilitates an odbc connection to the Sales Force world without the complication of using APIs.
  • Various other utilities to simplify ETL development.
  • We have run into compatibility issues or low level problems between SQL server and Task Factory. Working with both SentryOne and Microsoft, they both ended up blaming each other and not offering a fix.
Utilities such as Upsert have provided us with significant improvements in the reduction of repetitive code.

Because of bugs/complications with data type conversions (eg. Decimal to Numeric), care must be taken when converting numeric types.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
My department's role is to support business intelligence reporting of ITIL process areas. We are currently using Task Factory to perform ETL processing and data warehouse processing. We utilize the email task to send our reports in pdf format, and we also rely on the data warehouse fact processing task and the dimension processing task as it makes processing much smoother and easier to manage.
  • Advanced Email task makes it easier for an end-user to configure.
  • Fact Load task makes the data flow much easier to manage than the OOTB lookup function in SSIS.
  • Dimension Load task makes it easier to track multiple dimension types when loading into the DB.
  • Would really like to see an SSRS generate PDF output with parameter input.
  • Load improvement for larger datasets in the Upsert function.
  • Consistency with expressions for every task.
The Nulls processing task has really improved the speed it takes to transform null data. Otherwise, scripting is involved or a very lengthy derived column tasks will need to be developed. This would make it really hard to manage, especially when you have over 100 ETL processes to manage.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use Task Factory within our team. We have a need to ensure efficient ETL design to drive our high-performing data-centric application. Task Factory helps us reduce development time spent programming custom SSIS tasks, gives us components and tasks that are optimized to perform well in production, and a broad array of connections to various data platforms.
  • One-click Auditing Feature. Simply push a button, and all of your SSIS packages now have detailed auditing built-in, including the ability to watch it in real-time.
  • Wide variety of connections. If you need to connect to a common data source, Task factory will have what you need. No need to roll your own anymore.
  • The Upsert Component. Task Factory has a simple and FAST way to do an insert or update with new row data. It just works and works well.
  • SCD component could be a little more intuitive.
  • The help documents could be more detailed and current with what is actually released.
You should strongly consider Task Factory if you are a Microsoft Data platform shop. It really rounds out SSIS. If you don't know what SSIS is, then this is the wrong product for you.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use it for linking our SQL DB to the Salesforce cloud connection for data integration and a variety of other data processing components.
  • Easy to install, use and learn with basic SQL and SSIS knowledge.
  • Wider component selection available for different use cases.
  • I don't have any issues with the program.
It's a great tool to use. For the price, it's good for our use case to integrate SQL DB with the Salesforce cloud. This product was helpful to make the integration simple and robust.
Read this authenticated review
Peter Berrens | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
We are using Task Factory in our daily ETL processes. These processes are built and maintained by the Business Intelligence department
  • The task to call another package in a different solution
  • Advanced lookup and other tasks
  • Improvement can be achieved when new releases are tested better. We had a few times that our ETL stopped when implementing a new release.
When having a complex ETL environment and calling packages in different solutions, it's the only software we found that works according to expectations.
Read Peter Berrens's full review
Luca Campanelli | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
In our department, we use continuously and for several years Task Factory for the development of ETL through Micorosft Integration Services. I can assure you that it is absolutely an excellent product, without it the development of complex packages would certainly be longer, both in terms of time and in terms of effort in developing a lean and fast process.
  • Great time gain in terms of development.
  • Seamless integration with Integration Services.
  • It has an excellent component for developing SCD tasks.
  • It is an excellent program but it is obviously paid.
  • The license must be renewed regularly if the product is to be updated.
  • If you change visual studio version you need to update to the latest versions.
I recommend it in the most absolute way, as far as my specific case is concerned, I really use the task that deals with "Slowly Changing Dimensions" continuously, the speed of processing and processing of the records is truly remarkable, if you try it you will no longer unless you use it.
Read Luca Campanelli's full review
Mickeal Davis | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
Task Factory is used within our Business Systems team for the development of SSIS packages for ETLs into our data warehouse and other applications.
It speeds up development time by adding very useful transforms that are easier to use than the standard Microsoft transforms as well. It makes debugging and development faster.
  • Expression editor is by far better than that in standard SSRS.
  • The SharePoint destination and source is much easier to use than standard SSRS.
  • The slowly changing dimension transform is very easy to use and adds a level of capability that gives a better outcome.
  • More worked examples in the help.
Managing slowly changing type 2 dimensions along with auditing information is best done with the SCD Transform.
Read Mickeal Davis's full review
Steven Gockley, MBA, MCSA | TrustRadius Reviewer
May 29, 2019

Love Task Factory!

Score 10 out of 10
Vetted Review
Verified User
Review Source
We are heavy SQL Server Integration Services shop. There are a number of instances where we were faced with hand-coding solutions that would take hours or days to implement, but with Task Factory we were able to do it in seconds. We have a large number of highly visible, customer-facing processes that depend on Task Factory, and it has been very reliable and easy to use.
  • Our first use case was integrating with our Partners' Secure FTP Sites. Task Factory did this seamlessly.
  • Our second use case involved Excel. We have multiple groups that use Excel to monitor their processes, and using the Excel refresh task made this very quick and simple.
  • Our third use case was for SMTP. The basic SMTP did not give us enough control out of the box that we needed. We send out E-mails on behalf of our partners using their SMTP servers, so being able to change those connections effortlessly using this task was a huge time saver.
  • Not sure. I have not run into an instance where their transform didn't provide what I needed more easily than other solutions.
We use Task Factory a lot for our report automation. We have several use cases where we send out thousands of reports on a schedule to certain groups of customers, and Task Factory allows us to easily get files and move them via SFTP, FTP, or Email very easily. We have used it in our data warehouse as well, but not as heavily.
Read Steven Gockley, MBA, MCSA's full review
Karl Wiggins | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
We purchased Task Factory for one purpose - to connect to our production and development Dynamics 365 CRM environments via SSIS to internal SQL Servers for SSRS reporting.
  • Relatively easy to set up and use on a SQL Server.
  • Works like other connections in SSIS packages.
  • When Microsoft upgraded our Dynamics 365 install from version 8 to 9, we delayed the upgrade for several months. Once we moved our dev platform to version 9, Task Factory stopped working. After we pushed every delay we reasonably could in prod, Task Factory had still not been updated to work with version 9 of Dynamics 365. In the interim we tried another product that had already been updated in lockstep with Microsoft. The Task Factory folks seemed to indicate that they knew about the problems when we called, and sent us a hotfix eventually after two or three months. However, the delay convinced us to go to another product.
  • Weird or incorrect metadata in Dynamics 365 caused problems with the SSIS job whenever field changes were made in Dynamics 365. While this might not be the fault of Task Factory per se, our replacement product doesn't have this issue.
We had a very narrow use case for Task Factory - connecting to Dynamics 365 and pulling data down to an internal SQL Server for reporting. While it worked once it was set up, the long delay between the Dynamics 365 upgrade from version 8 to 9 (forced by Microsoft) and Task Factory's support for the new version forced us to another product.
Read Karl Wiggins's full review
Al Rubel | TrustRadius Reviewer
August 19, 2019

Task Factory Delivers!

Score 10 out of 10
Vetted Review
Verified User
Review Source
Used for data ETL and interfacing between databases and packages.
  • Data validation
  • Data cleaning
  • Quickly building interfaces between databases, non-database sources, and packages.
  • Would like to see more detailed documentation and examples.
Well suited for building complex interfaces.
Read Al Rubel's full review
Bob Amy | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
We bought Task Factory primarily for the bulk update and bulk task delete features. At the time we were looking to expand our customer base and all claim data related to it by four fold. By using Task factory within our SSIS, we were able to handle the extra load by only implementing the upsert and bulk updates into our existing integrations. There are a few other tools we also use, but bulk updating alone has more than paid for itself.
  • Bulk update, upsert and delete tasks.
  • Most tools work better than standard SSIS tools.
  • Built-in documentation is a plus.
  • I have not tried the generic nugget tools but would like to someday.
  • A full upsert with insert, update, and delete would be useful.
  • A full merge function that compares and makes all changes, including documenting either counts or by data that had to be corrected to synchronize.
The best use in my experience is the bulk updating.
Read Bob Amy's full review
Steve Mayer | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Task Factory was selected for two primary reasons. First and foremost, because of the extensive library of functions it makes available in SSIS to ease the SSIS programmer's job of importing and cleansing data. Second, because of the logging and notification features that it makes available which allow us to easily track the record counts of data we imported and easily notify us if there are issues with the execution of an SSIS process. Task Factory is used by our IT department, but we import data from 15-20 State agencies, so it indirectly affects many of our processes.
  • Better data cleansing and validation functions than are available in basic SSIS.
  • Better database insert and update functions than in SSIS.
  • Ease of use of functions provided.
  • Re-introduce the prior feature to allow a user to copy or move SSIS variables from one package or scope to another.
  • Provide a better upgrade path from one version of the product to another higher version. Our upgrade from 2008 to 2016 was quite complex and it seemed as though we might have been the first such upgrade Pragmatic Works had encountered.
I would definitely recommend the product for any SSIS project. We saw its benefits from the very beginning, even when we had only a few SSIS packages. We are now up to over 120 SSIS packages and process files from over 20 sources on a regular basis, including weekly, monthly, quarterly and annually. We cleanse the data and use it to build data warehouses and SSAS cubes for consumption by numerous State agencies.
Read Steve Mayer's full review
Matt Cushing | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use several components in our daily process to import data into our data warehouse. It allowed us to easily import Sharepoint data and grab emailed Excel attachments to process. It made it easier to accept and parse JSON data.
  • The ability to use the email source to play with individual messages in a mailbox is key. We get a lot of attachments that we download based on attachment extension and subject content to place them in network directories for further processing.
  • The ability to pull from Sharepoint lists that easily was a game changer. We can allow our users to maintain content that we can then consume and push to our data warehouse.
  • The REST source was easy to implement and utilize to pull data from vendor APIs.
  • The documentation could use some polishing, though I have seen significant improvement now that SentryOne took over.
  • Prebuilt templates or examples available for use to jumpstart development efforts.
We had 3rd parties sending attachments to multiple members of our teams. We had them redirect to a specific mailbox for processing. Then we used the "email move/delete" to strip the attachment and load it to a network share, and finally, we used the "email move/delete" task to shift the processed email into another folder so it wouldn't reprocess.
Read Matt Cushing's full review
Ryan Lundahl | TrustRadius Reviewer
July 30, 2019

Worth a try!

Score 5 out of 10
Vetted Review
Verified User
Review Source
We use Task Factory on the BI team to help with data connectors in SSIS and with tracking our nightly jobs. This solves writing custom code to handle certain data connectors.
  • Job management
  • Data Connectors
  • Easy to Use
  • It is hard to justify keeping a license when your platforms are adding the same functionality that Task Factory provides. This must keep ahead of software providers to justify the use.
We use Task Factory for monitoring our nightly jobs and adding functionality to SSIS in the form of custom connectors. Task Factory does a good job in these areas.
Read Ryan Lundahl's full review
Kang Chen | TrustRadius Reviewer
June 02, 2019

#1 SSIS plug-ins

Score 8 out of 10
Vetted Review
Verified User
Review Source
It's used as the ETL tool for our data warehouse, which has impact on many departments and applications.
  • Slow changing dimension component helps the Data Warehouse ETL process
  • Salesforce source/destination component helps the integration
  • SFTP component is very useful
  • Slow changing dimension component has some bug on the hash key comparison
It's very useful for integrating different data sources and supporting ETL functions.
Read Kang Chen's full review
Edward Chow | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
Task Factory is used by IT and Research. It is used in the ETL process in the data warehouse, and also many aux SSIS projects that involve moving data from one source to another. It is also used in various migration and data restructuring projects.
  • It provides some less common connectors such as SFTP.
  • The PGP component is very easy to use as it support a cross platform encryption standard.
  • The Upsert Destination is vastly superior than the build in ADO or OLE destination.
  • The PGP task involves some hardcode parameter.
  • The Surrogate key component does not fetch a new key automatically based on the current maximum key.
Task Factory should be considered for SSIS whenever one of the following is true:
- it requires lots of insert and updates
- it needs less common connector
- it needs to work with external source / destination with PGP support
Read Edward Chow's full review

Task Factory Scorecard Summary

Feature Scorecard Summary

Connect to traditional data sources (31)
Simple transformations (30)
Complex transformations (28)

About Task Factory

According to the vendor, Task Factory offers essential, high-performance components and tasks for SQL Server Integration Services (SSIS) that eliminate the need for programming. With over 50 components, Task Factory aims to increase productivity, improve performance and increase ROI.

Task Factory components include:

Dimension Merge SCD Transform
Upsert Destination
Fact Table Destination
Rest Source
Salesforce.com Source/Destination
Microsoft Dynamics CRM Source/Destination
Marketo Source/Destination
Secure FTP Task
File Gateway Task
Data Cleansing Transform
Data Validation Transform
Error Output Description Transform
PGP Encryption Task
Unpack Data Transform
XML Destination
XML Generator Transform

Task Factory Features

Data Source Connection Features
Has featureConnect to traditional data sources
Does not have featureConnecto to Big Data and NoSQL
Data Transformations Features
Has featureSimple transformations
Has featureComplex transformations
Data Modeling Features
Does not have featureData model creation
Does not have featureMetadata management
Does not have featureBusiness rules and workflow
Does not have featureCollaboration
Does not have featureTesting and debugging
Does not have featurefeature 1
Data Governance Features
Does not have featureIntegration with data quality tools
Does not have featureIntegration with MDM tools

Task Factory Screenshots

Task Factory Videos (6)

Task Factory Downloadables

Task Factory Integrations

Microsoft SQL Server, Salesforce.com, MS SharePoint, Marketo, Hadoop, Microsoft Dynamics 365 (formerly Microsoft Dynamics CRM), Twitter, LinkedIn, Facebook, Azure Machine Learning, SSIS Rest Source

Task Factory Competitors

Microsoft SQL Server Native SSIS Components, Codeplex, Devart


  • Has featureFree Trial Available?Yes
  • Has featureFree or Freemium Version Available?Yes
  • Has featurePremium Consulting/Integration Services Available?Yes
  • Entry-level set up fee?No
EditionPricing DetailsTerms
Standard Edition (30 SSIS tasks & components)1,795per server
Pro Edition (60 SSIS tasks & components)2,495per server
Azure Data Factory1,495per ADF node (subscription only)
Pro Edition Maintenance$499per year
Standard Edition Maintenance$359per year
Comunity Edition$0free

Task Factory is priced per Microsoft SQL Server instance. Any Microsoft SQL Server that executes an SSIS package containing Task Factory components requires a licenses. Users can install Task Factory custom components and use within VIsual Studio at no cost.

Task Factory Customer Size Distribution

Small Businesses (1-50 employees)
Mid-Size Companies (51-500 employees)
Enterprises (> 500 employees)

Task Factory Support Options

 Free VersionPaid Version
Live Chat
Social Media
Video Tutorials / Webinar

Task Factory Technical Details

Deployment Types:On-premise
Operating Systems: Windows
Mobile Application:No
Supported Languages: English