SSIS

The ability of SSIS to integrate different technologies manipulates data, like “fuzzy logic” based data cleansing components. Support for complex data routing in SSIS allows anomalous data to not only be identified, but also be automatically corrected and replaced with better values. This enables “closed loop” cleansing scenarios. In addition to its built-in data quality features, SSIS can be extended to work closely with third-party data-cleansing solutions