Task Factory saves vast amounts of time
September 10, 2019

Task Factory saves vast amounts of time

Brett Archer | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Task Factory

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
  • The amount of time to manually create Insert/Updates has drastically been reduced. We probably easily paid for the license in the first month of use.
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.

SolarWinds Task Factory Feature Ratings

Connect to traditional data sources
10
Simple transformations
10
Complex transformations
10