Sort Plus

Overview

Sort
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.

SSH Execute Task

Overview

SSH Execute Task The SSH Execute Task is an SSIS Control Flow task for secure execution of shell commands on a remote SSH server.

Stream Task

Overview

Stream Task The Stream Task is an SSIS Control Flow task for management and manipulation of the standard Stream object.

Table Difference

Overview

Table Difference The Table Difference Component is an SSIS Data Flow Component designed to find differences between two tables and, in particular, to simplify the management of slowly changing dimensions. The main advantage over the Microsoft standard SCD component is the speed and ease of use.

Query

Overview

Query The Query Component is an SSIS Data Flow Component providing the ability to retrieve data from a SQL database by defining data flow input columns as query keys. The Query component supports a variety of connection types as a source.

Pages