Upgrade to Upsert
April 30, 2020
Upgrade to Upsert
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Task Factory
Our prima facie need was to increase the speed for loading our data warehouses. We used SSIS, and needed an easy way to convert to bulk updates and deletes. Task Factory offers several tools that reduce our load time by about 60 times. These are Upsert, Bulk Update and Bulk delete. We were already using the SSIS fast load, but had we had Task Factory earlier, it would have saved a huge amount of development. We have used a few of the other tools as well, but unfortunately, our addition of Task Factory was retrofit and not new development.
- Fast, large updates and deletes.
- Simple Upsert logic.
- Very nice integrated help, including video.
- Easy to install, well documented, and easy to use.
- Support was excellent under Pragmatic Works. I cannot attest to Sentry One.
- We had one case of an upgrade that would not work with existing code. They did release a next version very quickly.
- Task Factory allowed us to quadruple our data volume without scaling out our systems. Just implementing the fast update tools improved SSIS performance enough to maintain SLAs.