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!
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.