Brian Knight is the owner and founder of Pragmatic Works and is a serial entrepreneur, starting up other companies throughout his prolific career. Brian is a contributing columnist at several technical magazines and does regular webcasts. He is the author of more than fifteen technical books.
We got Task Factory mostly because of PragmaticWorks reputation for the service they provide and the specific need of a secure SFTP task.
The University of Calgary Data Warehouse consists of over two dozen data marts, built upon a decade's worth of ETL programming in IBM Cognos Data Manager. When support for that product ended and we investigated converting all ETL to SSIS, concerns were raised about performance and maintainability in the new toolset. Thus the decision was made to purchase Pragmatic Works Task Factory; I can say with confidence that halfway into the conversion effort, it has been one of our smartest and most cost-effective software acquisitions in recent memory.