To clean up your data within your ETL process, HEDDA.IO provides an SSIS component for validation, standardization and enrichment.
The component uses the specially developed Batch API mode to check and correct mass data with a high speed kit. The component offers you a wide range of settings, e.g. to deal with incorrect or new data records.
The SSIS component can be used both in SSIS packages of SQL Server 2012-2019 and with the Azure SSIS-IR. This allows you to run your entire Data QUality workflow in Azure.