However this time last year there were two features of SSIS which I thought Alteryx lacked.
The first was the ability to hide away sections of the module in collapsible sections. At Extend 2010 Ned demonstrated this same functionality in Alteryx courtesy of Tool Containers. After that demo I mentioned to Ned that now there was only one thing which I thought was better about SSIS than Alteryx, namely the displaying of record counts on data connections.
Well now in Alteryx 2011 we have connection progress in real time as data flows through them. These are a great new feature and allow users to:
- See progress of the module more easily
- See mistakes in their module before it completes processing
- Easily check joins and filters are behaving as expected without needing to cross reference to the log
- Identify inefficiencies in their modules
I agree, and I especially like the new Tool Containers. In the past I would always create new modules containing "pieces" of a whole module. Once every piece was tested, I would then combine into one module for the finished process. The Tool Containers now make it much easier to test the different parts of a complete module, all within one module. Combined with the Connection Progress functionality, it is even easier to debug a module towards completion.