In this example, we will create an SSIS project and get some customer information from an Excel file and apply the Address KB rules on the information with the DQS cleansing component and check the result. For this example, we only show results in a data viewer in SSIS, but in real-world scenarios, you might need to export the results into a destination or use them as the source of another transformation. Perform the following steps to create a cleansing component:
Open SSDT, create a new Integration Service project, and name it
Chapter 05 Data Quality Services
.Create a Data Flow task and then go to the Data Flow tab.
Create an Excel source, connect it to the
KB Parsing.xlsx
file, set the first row as header, preview data, and close this component.Drag-and-drop a DQS cleansing component from the SSIS toolbox under the Excel source and connect the data path from the Excel source to this component.
In the DQS Cleansing Transformation editor...