A complete package of additional tasks for SSIS
July 19, 2019

A complete package of additional tasks for SSIS

Luca Campanelli | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Task Factory

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.
  • 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.
No other product was considered because we knew we were safe with this product even when it was still Pragmatic Works (now Sentry One). Before using this product, we downloaded additional third-party tasks, some freeware, but a complete package like the one offered by sentry one is not very easy and above all remains reliable over the years.
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.

SolarWinds Task Factory Feature Ratings

Connect to traditional data sources
Simple transformations
Complex transformations