- The single most beneficial component to Task Factory is the Upsert component. If you're familiar with writing MERGE statements in T-SQL, you'll appreciate the Upsert component. Drag the component into your Data Flow and a few clicks later you have a MERGE without the code complexities.
- Where some native SSIS components leave you wanting more, Task Factory extends on many of these components as well as support for data sources not native to SSIS components.
- The number of extra components that come in the Task Factory tool kit will expand your tool belt to do just about anything you need or want to accomplish in SSIS.
- Limited to only running on a licensed server or in BIDS. We have development servers that require licensing as well, but I've had to get creative to be able to execute packages against non-licensed servers.
- Wish the logging was more detailed when components error.
- Not alerted when a new version is available.
We have had our challenges with the Salesforce connection. It does not seem to process as efficiently as we'd like.
Task Factory Scorecard Summary
Feature Scorecard Summary
About Task Factory
Task Factory Screenshots
Task Factory Integrations
Task Factory Competitors
|Standard Edition||1,495||per server|
|Professional Edition||1,995||per server|
Task Factory is priced per Microsoft SQL Server. Any Microsoft SQL Server that executes an SSIS package containing Task Factory components requires a licenses. Users can install Task Factory custom components and use within VIsual Studio at no cost.
Task Factory Customer Size Distribution
|Small Businesses (1-50 employees)||0%|
|Mid-Size Companies (51-500 employees)||25%|
|Enterprises (> 500 employees)||Enterprises (> 500 employees)||75%|
Task Factory Support Options
|Free Version||Paid Version|
|Video Tutorials / Webinar|
Task Factory Technical Details