A complete package of additional tasks for SSIS
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.
Pros
- Great time gain in terms of development.
- Seamless integration with Integration Services.
- It has an excellent component for developing SCD tasks.
Cons
- 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.
Comments
Please log in to join the conversation