I would use Task Factory even if it cost more!
November 23, 2019

I would use Task Factory even if it cost more!

John C Hill | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Task Factory

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.
  • It has had a great effect on our ROI as my time to develop has been reduced dramatically.
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.

SolarWinds Task Factory Feature Ratings

Connect to traditional data sources
9
Simple transformations
8
Complex transformations
8