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