TrustRadius
https://media.trustradius.com/product-logos/XS/vW/DDWOUTBAHFEH.JPEGTask Factory made things possibleWe 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.,8,We are able to run our ETL without manual intervention, so we spent fewer hours on this.,It has and it's hard to say how much time, but we save a few hours daily since it runs fully automatic.,Microsoft SQL Server,Microsoft SQL Server, Microsoft 365 BusinessA complete package of additional tasks for SSISIn 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.,10,Less resources needed to complete a complex task. Much time gained during the development of an ETL package. Easy identification of errors during data import.,Without the use of task factory, a lot of ETL processes should be developed with much more cumbersome architectures, the controls on moving data should be done manually, requiring much more development time but also data processing time. Another example can also be the upload to SFTP areas that through task factory is managed very simply with a specific task. In short, it is really very very comfortable.,,SQL Server Integration Services, Microsoft SQL Server, Microsoft Access, Qlik Sense, QlikView, ASG-Remote Desktop, Redgate SQL Data Compare, Redgate SQL CompareBetter quality outcomes with less code cuttingTask 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.,10,It actually simplifies the SSIS packages and means there are less steps within a package. We have high staff turnover so using TaskFactory gets new employees able to understand and maintain existing packages faster.,Yes it has, especially on complex transformations with extensive cleansing required. The trim and null handling functions remove the need for script components.,Love Task Factory!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.,10,Huge ROI. With the SFTP and Advanced SMTP it saved us weeks in changes and hard coding that we would have had to do and maintain. The cost of the license was recovered the first day we installed Task Factory.,Before we purchased Task Factory we had already spent about 2 man-weeks on different solutions that would almost work. Once we installed Task Factory we had the original need changed and implemented into production in under an hour. If we would have had Task Factory from the beginning, we would have saved thousands in development costs.,,Microsoft Visual Studio Code, SQL Server Integration ServicesTask Factory works great, as long as you can wait a long time between upgradesWe 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.,7,Initial impact was positive. Task Factory was not very expensive, and it worked. Once Microsoft upgraded Dynamics 365 from version 8 to 9, Task Factory did not support the new version for several months after our upgrade, and we had delayed our production upgrade for at least four months. This forced us to buy another competing product that did support version 9. Licensing did not allow us to install the product on developer workstations for test/dev without buying another product license, but this is not a particular weakness of Task Factory. In other words, other products we have used had the same limitation. Still, it forces us to modify SSIS packages directly on the server as opposed to our laptops.,So, Task Factory did provide extended SSIS components for Dynamics 365. However, since they were not able to keep up with the pace of Microsoft's updates to Dynamics 365, the productivity and time saving benefits were limited, as we had to find another competing product to replace that functionality. I have no idea whether this is the case for other platforms, but we came away disappointed.,,VMware ESXi, Microsoft SQL Server, Microsoft Office 365, Microsoft Power BI, Microsoft Teams, Microsoft Dynamics 365 (formerly Microsoft Dynamics CRM), Microsoft Dynamics GP, Redgate SQL Compare, Spotlight, Microsoft Visual Studio Code, UltiProTask Factory Delivers!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.,10,ROI was immediate.,Task Factory has reduced design, development and test time by 75%.,CozyrocGet Task Factory before you write a bunch of SSIS code using the RBAR method.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.,10,Reduces the need to double our computing environment. Makes development much easier.,Using Task Factory cuts our programming work in half.,,JIRA Software, Cloudera Enterprise Data Hub, Talend Data IntegrationThumbs Up for Task Factory!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.,9,The product allows us to develop SSIS packages more quickly than standard SSIS. Pragmatic Works (now SentryOne) offers training on SSIS, SSAS and other topics that have been very beneficial to our staff members and allowed us to train staff without sending them to classes, as the training is offered in an online format. Pragmatic Works (SentryOne) has a great support team that provides help when you need it, and offers Mentoring Hours to allow you to get help from consultants when you hit issues on which you need assistance.,Yes, it has definitely provided this time-saving benefit. It is hard to quantify this in an amount of time saved, since we did not develop SSIS packages without, using Task Factory but I would estimate it has saved us at least 30% over trying to develop these same packages without Task Factory.,,Visual Studio IDE, SQL Server Integration Services, Microsoft SQL ServerStop banging your head against the wall and get the tools to blow through it! Get Task Factory!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.,10,We've been able to consolidate our data into one place and automate things to allow our users to spend their time wisely instead of on manual processes.,We saved a lot of time by storing our maintained lists in Sharepoint now that Task Factory allows such easy access to the data. We're just starting to scratch the surface of some of the other tools to allow us to be more productive and efficient.,ZappySys,Visual Studio IDE, Slack, Microsoft TeamsWorth a try!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.,5,That is really hard to calculate and I don't think it is worth my time to do so for this survey :),This is definitely a time saver, but more and more components are being added natively all the time by MS so its value is decreasing. Overall though this has saved us probably 400 hours.,#1 SSIS plug-insIt'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,8,It provides many components that help us to integration data from different systems.,Yes, it does provide this benefit. It saved 30%-40% our development time.,Cozyroc,Microsoft SQL Server, Microsoft Power BI, .NETGood for any non trivial SSIS projectTask 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.,10,Task factory simplify lots of SSIS projects.,Task Factory components are easy to use and behave fairly similarly with the build in SSIS components. The functionality provided can probably reduce 20-30% of development and testing time for any non trivial SSIS project.,Solve the problem without codingWe mainly use Task Factory to connect to third-party data source via REST. We were looking for a third-party connector of SSIS for Google Analytics in 2018. After evaluating a couple of vendors, we purchased Task Factory. It is mainly used by the Business Reporting Analytics team for ETL purposes.,Retrieve data from various REST sources Data cleansing Data importing,Offer more options in UI for different configurations of REST sources More details in documents It appears that REST connectors do not work well with Okta in place.,8,We are able to import different data from an external/cloud service into our own server for data analytic purposes.,With Task Factory, we were able to retrieve Google Analytic data without one line of coding.,Microsoft Power BITask Factory fills in the blanks with an excellent ROI and low total cost of ownership.We use Task Factory to fill in the missing pieces in the SSIS toolbox.,By filling in the blanks where SSIS doesn't do everything it needs to do, Task Factory makes SSIS a truly useful ETL tool. Task Factory is intuitive and very easy to roll out. Versus the cost of paying for other tools or expensive custom development work, Task Factory is a deal.,No complaints whatsoever about Task Factory. It does everything we expect it to do and performs well.,10,Task Factory eliminates most of the need to write custom scripts to do the things SSIS should have done but doesn't do or doesn't do well. By saving developer time, Task Factory makes those precious development hours available to more important things. In my opinion, Task Factory pays for itself at least ten times over in the first year of use, all costs considered.,As mentioned other places in my review of Task Factory, by filling in the blanks where SSIS on its own falls short, the need for custom script development, strange workarounds, and other costly mistakes can be avoided. Time saved is not only money saved but the time that is available for other work. Time is the one thing you cannot get back--once it's gone, it's gone--and Task Factory has saved us a lot of time.,ZappySys,Visual Studio IDE, SQL Server Integration Services, Windows ServerSFTP: don't try it without Task FactoryWe now use Task Factory primarily for Secure FTP, however, we originally purchased it for the ability to read and extract data from emails. We have a number of interfaces in various departments that require exchanging data with third parties via SFTP and Task Factory handles this need excellently.,SFTP,Better documentation/help. Task Factory is powerful but I have had to search the web for examples of how to configure things.,10,We haven't tried to measure ROI in regards to Task Factory, it is a tool we needed to fill a gap in the standard SSIS toolbox.,Task Factory has definitely saved us time but we do not have a measure of how much.,Redgate SQL MonitorTask Factory simplifies your workflowUsed by the BI department. Simplifies some file & SQL related transformations.,File related tasks. PGP tasks. Web related tasks.,Create a snowflake transform - source & destination. simplify SCD transform - too many options.,8,pretty good so far - although it does seem a little expensive.,Agreed. SCD transforms are a good time saver.Task Factory is great day to dayWe're using Task Factory in our data warehouse processes. It helps solve various data cleanup and data flow problems.,Easy to use and implementation. Great components to help easily solve procedural issues in SSIS.,I would like to see source and destination components for Snowflake.,10,Task Factory has had a positive impact on our ROI for ease of use and the problems it helps us solve.,I don't have a quantified number but I know that Task Factory makes my job easier when I'm developing in SSIS.,Redgate SQL Compare, SQL Server Integration Services, SnowflakeTask Factory ReviewTask Factory is implemented by our database development and BI teams for use in supporting ETL requests from all departments within the organization. Task Factory has streamlined the process of loading data from many disparate data sources including flat files, Excel, XML, other database and cloud platforms. What could take many hours to write in SQL or to derive in native Microsoft SSIS components now takes as little as a few minutes to implement with Task Factory.,The single most beneficial component to Task Factory is the Upsert component. If you're familiar with writing MERGE statements in T-SQL, you'll appreciate the Upsert component. Drag the component into your Data Flow and a few clicks later you have a MERGE without the code complexities. Where some native SSIS components leave you wanting more, Task Factory extends on many of these components as well as support for data sources not native to SSIS components. The number of extra components that come in the Task Factory tool kit will expand your tool belt to do just about anything you need or want to accomplish in SSIS.,Limited to only running on a licensed server or in BIDS. We have development servers that require licensing as well, but I've had to get creative to be able to execute packages against non-licensed servers. Wish the logging was more detailed when components error. Not alerted when a new version is available.,9,Task factory has saved our company thousands of dollars in development time. If money is no concern then licensing your Task Factory for all SQL Servers in your environment is the way to go. However, you could operate in an environment that has a dedicated SSIS bus that manages all packages on all servers. In that architecture, your single license will be sufficient. We recently retired a legacy system and moved the data to Salesforce. We now use task factory to support building our data warehouse from a replicated copy of Salesforce data. The tools allow for simple and quick additions to an ever changing Salesforce and warehouse environments.,,Boomi, SQL Sentry, Bamboo
Windows
Task Factory
29 Ratings
Score 8.1 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Task Factory Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Task Factory
29 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.1 out of 101

Do you work for this company? Manage this listing

Show Filters 
Hide Filters 
Filter 29 vetted Task Factory reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role

Reviews (1-18 of 18)

Do you use this product? Write a Review
Peter Berrens profile photo
August 19, 2019

Task Factory made things possible

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 profile photo
July 19, 2019

A complete package of additional tasks for SSIS

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 profile photo
July 16, 2019

Better quality outcomes with less code cutting

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 profile photo
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 profile photo
May 14, 2019

Task Factory works great, as long as you can wait a long time between upgrades

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 profile photo
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 profile photo
April 20, 2019

Get Task Factory before you write a bunch of SSIS code using the RBAR method.

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 profile photo
April 19, 2019

Thumbs Up for Task Factory!

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 profile photo
April 06, 2019

Stop banging your head against the wall and get the tools to blow through it! Get Task Factory!

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 profile photo
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 profile photo
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 profile photo
May 28, 2019

Good for any non trivial SSIS project

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
No photo available
May 29, 2019

Solve the problem without coding

Score 8 out of 10
Vetted Review
Verified User
Review Source
We mainly use Task Factory to connect to third-party data source via REST. We were looking for a third-party connector of SSIS for Google Analytics in 2018. After evaluating a couple of vendors, we purchased Task Factory. It is mainly used by the Business Reporting Analytics team for ETL purposes.
  • Retrieve data from various REST sources
  • Data cleansing
  • Data importing
  • Offer more options in UI for different configurations of REST sources
  • More details in documents
  • It appears that REST connectors do not work well with Okta in place.
A set of flexible components for SSIS for users who have needs for various data sources. With Task Factory, we were able to retrieve Google Analytic data without one line of coding.
Read this authenticated review
No photo available
May 08, 2019

Task Factory fills in the blanks with an excellent ROI and low total cost of ownership.

Score 10 out of 10
Vetted Review
Verified User
Review Source
We use Task Factory to fill in the missing pieces in the SSIS toolbox.
  • By filling in the blanks where SSIS doesn't do everything it needs to do, Task Factory makes SSIS a truly useful ETL tool.
  • Task Factory is intuitive and very easy to roll out.
  • Versus the cost of paying for other tools or expensive custom development work, Task Factory is a deal.
  • No complaints whatsoever about Task Factory. It does everything we expect it to do and performs well.
I highly recommend Task Factory as a low-cost, high-value addition to the SSIS toolbox.
Read this authenticated review
No photo available
April 27, 2019

SFTP: don't try it without Task Factory

Score 10 out of 10
Vetted Review
Verified User
Review Source
We now use Task Factory primarily for Secure FTP, however, we originally purchased it for the ability to read and extract data from emails. We have a number of interfaces in various departments that require exchanging data with third parties via SFTP and Task Factory handles this need excellently.
  • SFTP
  • Better documentation/help. Task Factory is powerful but I have had to search the web for examples of how to configure things.
SFTP is the only thing we use Task Factory for at the moment but it is very well suited for the task.
Read this authenticated review
No photo available
August 01, 2019

Task Factory simplifies your workflow

Score 8 out of 10
Vetted Review
Verified User
Review Source
Used by the BI department. Simplifies some file & SQL related transformations.
  • File related tasks.
  • PGP tasks.
  • Web related tasks.
  • Create a snowflake transform - source & destination.
  • simplify SCD transform - too many options.
Good for basic & advanced transforms.
Not so good to keep things updated.
Read this authenticated review
No photo available
June 21, 2019

Task Factory is great day to day

Score 10 out of 10
Vetted Review
Verified User
Review Source
We're using Task Factory in our data warehouse processes. It helps solve various data cleanup and data flow problems.
  • Easy to use and implementation.
  • Great components to help easily solve procedural issues in SSIS.
  • I would like to see source and destination components for Snowflake.
Task Factory is well suited for all SSIS packages no matter what business process they're for.
Read this authenticated review
Frank Coulter profile photo
March 21, 2017

Task Factory Review

Score 9 out of 10
Vetted Review
Verified User
Review Source
Task Factory is implemented by our database development and BI teams for use in supporting ETL requests from all departments within the organization. Task Factory has streamlined the process of loading data from many disparate data sources including flat files, Excel, XML, other database and cloud platforms. What could take many hours to write in SQL or to derive in native Microsoft SSIS components now takes as little as a few minutes to implement with Task Factory.
  • The single most beneficial component to Task Factory is the Upsert component. If you're familiar with writing MERGE statements in T-SQL, you'll appreciate the Upsert component. Drag the component into your Data Flow and a few clicks later you have a MERGE without the code complexities.
  • Where some native SSIS components leave you wanting more, Task Factory extends on many of these components as well as support for data sources not native to SSIS components.
  • The number of extra components that come in the Task Factory tool kit will expand your tool belt to do just about anything you need or want to accomplish in SSIS.
  • Limited to only running on a licensed server or in BIDS. We have development servers that require licensing as well, but I've had to get creative to be able to execute packages against non-licensed servers.
  • Wish the logging was more detailed when components error.
  • Not alerted when a new version is available.
The single most used component in our Task Factory toolbelt is the Upsert component. The time this component has saved our developers alone paid for the product in the first few months. If you've ever attempted to use the native SSIS components to do upserts, or gone the route of writing your own upsert/merge statements, you'll appreciate this component. Another component that helps in the debugging stage is the Terminator Destination component. This component allows you to test your source inside a Data Flow without the need to having a destination.
We have had our challenges with the Salesforce connection. It does not seem to process as efficiently as we'd like.

Read Frank Coulter's full review

Task Factory Scorecard Summary

Feature Scorecard Summary

Connect to traditional data sources (18)
8.1
Simple transformations (17)
8.1
Complex transformations (16)
7.6

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

Pricing

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

Consumers
0%
Small Businesses (1-50 employees)
0%
Mid-Size Companies (51-500 employees)
25%
Enterprises (> 500 employees)
75%

Task Factory Support Options

 Free VersionPaid Version
Phone
Live Chat
Email
Forum/Community
FAQ/Knowledgebase
Social Media
Video Tutorials / Webinar

Task Factory Technical Details

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