The Sort Plus Component is an SSIS Data Flow asynchronous transformation component, which is capable of sorting very 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 and is capable of handling MILLIONS of rows with ease.

The first input is used as a basis for selecting output columns and sorting keys. The others must have the same structure (i.e. columns with the same names and data types). For optimal throughput, the data from all inputs is processed in parallel.

Parameters:

Remove duplicate entries
Maximum memory
Maximum threads
Blob columns maximum bytes
Temporary files folder
MaxParallelOffloads
LoggingLevel

COZYROC SSIS+ Suite is free for download and development within Visual Studio

Free developer license. You don't need a license key for testing and development
Support for SQL Server 2022 - 2012
COZYROC SSIS+ suite includes more than 270 SSIS components and tasks for ETL and Data Integration
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud

Data Flow Task Plus allows creation of Dynamic data flows at runtime and can be used with COZYROC's Airtable components. This powerful feature requires no programming skills to use and greatly simplifies your maintenance efforts.

Check the SSIS Data Flow Task demo video in our Youtube channel

See also:

COZYROC SSIS REST framework video. With the COZYROC SSIS REST framework you can connect to any Web service and consume any Web API. Free for download and development https://www.cozyroc.com/ssis/rest
For a full compatibility list and more information about the COZYROC SSIS+ Components, please visit the COZYROC website

Sort Plus SSIS ComponentCOZYROC

Sort Plus SSIS Component

COZYROC

Sort Plus SSIS Component

COZYROC

Sort Plus SSIS Component
COZYROC