Overall Satisfaction with Task Factory
Task Factory is used by IT and Research. It is used in the ETL process in the data warehouse, and also many aux SSIS projects that involve moving data from one source to another. It is also used in various migration and data restructuring projects.
- It provides some less common connectors such as SFTP.
- The PGP component is very easy to use as it support a cross platform encryption standard.
- The Upsert Destination is vastly superior than the build in ADO or OLE destination.
- The PGP task involves some hardcode parameter.
- The Surrogate key component does not fetch a new key automatically based on the current maximum key.
- Task factory simplify lots of SSIS projects.
We have not considered other products.