Versions:
SSIS Multiple Hash 1.7.6.0, released by Keith Martin, is a single-version SQL Server Integration Services component engineered to extend data-flow pipelines with synchronous, row-level cryptographic hashing. Acting as a transformation task within Business Intelligence and Data Integration projects, the tool accepts any inbound rowset and, in one pass, produces multiple hash digests per record, eliminating the need for successive script components or external executables. Typical use cases centre on ETL auditing, deduplication, change-data-capture surrogate key generation, and secure data exchange, where matching or verifying rows across systems demands consistent, collision-resistant identifiers. The component surfaces two widely adopted algorithms—MD5 for legacy compatibility and high-speed checksums, and SHA-1 for moderately stronger integrity checks—letting architects balance performance against security requirements without leaving the SSIS design surface. Because it operates in-memory and remains fully synchronous, data flow execution plans retain high throughput while CPU cost stays predictable, an advantage when loading large data warehouses or synchronising multi-terabyte replication feeds. Configuration is handled through standard SSIS component editors, so package developers can assign input columns, select algorithms, and direct hexadecimal or base-64 encoded output to new derived columns without custom scripting, reducing maintenance overhead and deployment risk. The utility is categorised under Database Software > ETL Tools and integrates cleanly with Visual Studio 2012–2022 SQL Server Data Tools projects targeting SQL Server 2012 and later. SSIS Multiple Hash is available free of charge on get.nero.com, where downloads are furnished through trusted Windows package sources such as winget, always supply the newest build, and support unattended batch installation alongside other applications.
Tags: