SSIS Component – Search Parameter
The core functions within the search are the search parameters and the algorithms used. Use multiple search parameters to find all possible duplicates. Within a search parameter, you specify a …
SSIS Component – Sort Key
Sort keys are defined to adjust the search with the Sliding Window to your search parameters. Each sort key is composed of the number of characters you define under “Character”. …
SSIS Component – Data Mapping
In the Data Mapping tab, you can see exactly which columns of the data flow are used and how. Parameter This column specifies whether a data flow column is used …
SSIS Component – Information
On the Information tab you can find all license information for your component. If the component is not properly licensed, please follow the instructions in the Information Tab to license …
Algorithms
To get the best results for your data with our search, SQLPhonetics.NET has more than 10 different search functions and algorithms. Each algorithm is optimized for certain data types / …
SSIS Component – Configuration
The Configuration is the first tab of the SSIS component. Here you define the basic properties of the SSIS component. Profile Depending on the selected …
Simple example
In the following we will create a simple example to find duplicates using SQLPhonetics.NET for SSIS. In this example, we first load data from a table. The data comprises the …