Reviews (1-18 of 18)
- 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.
- 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.
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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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 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.
- it requires lots of insert and updates
- it needs less common connector
- it needs to work with external source / destination with PGP support
- 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.
- No complaints whatsoever about Task Factory. It does everything we expect it to do and performs well.
Not so good to keep things updated.
- 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.
We have had our challenges with the Salesforce connection. It does not seem to process as efficiently as we'd like.
Task Factory Scorecard Summary
Feature Scorecard Summary
About Task Factory
Task Factory Screenshots
Task Factory Videos (6)
Task Factory Downloadables
Task Factory Integrations
Task Factory Competitors
|Standard Edition (30 SSIS tasks & components)||1,795||per server|
|Pro Edition (60 SSIS tasks & components)||2,495||per server|
|Azure Data Factory||1,495||per ADF node (subscription only)|
|Pro Edition Maintenance||$499||per year|
|Standard Edition Maintenance||$359||per year|
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)||0%|
|Mid-Size Companies (51-500 employees)||25%|
|Enterprises (> 500 employees)||75%|
Task Factory Support Options
|Free Version||Paid Version|
|Video Tutorials / Webinar|
Task Factory Technical Details