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 …
Azure SSIS IR Installation (Integration Runtime Setup)
To use the component with the Azure SSIS Integration Runtime, the component must be installed and configured on the corresponding Azure nodes. The actual installation and licensing of the component …
Licensing SQLPhonetics.NET for SSIS
SQLPhonetics.NET comes standard with a 30-day trial version. With this version you can create full-featured SSIS packages and run the packages. The runtime environment of SQLPhoentics.NET processes all data records, …
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 …
Azure SSIS IR Installation (PowerShell)
To use the component with the Azure SSIS Integration Runtime, the component must be installed and configured on the corresponding Azure nodes. The actual installation and licensing of the component …