The Sort Plus Component is an SSIS Data Flow asynchronous transformation component, which is capable of sorting large amounts of data. It uses a sophisticated proprietary algorithm that employs smart chunking and caching of data on disk. It enables an optimal utilization of your server's resources, by doing all processing in parallel, using a configurable number of threads.
With smaller amounts of data (e.g. well below 1GB), its speed is similar to the speed of the built-in Sort component. However, unlike the built-in Sort component which usually hangs when trying to process big volumes of data (e.g. more than 2 GB), our Sort Plus component completes its job and does so in a reasonable time.
Unlike the built-in Sort transformation, Sort Plus supports multiple inputs.
The COZYROC SSIS+ Suite also includes the powerful and elegant Data Flow Task Plus, not found in any other competitive product on the market.
Support for SQL Server 2005, 2008, 2012, 2014, 2016, 2017, 2019
Get in touch with us: