- Home
- Developer Center
- Documentation SSIS Data Masking Components
- Generic Phone Nu
SSIS Data Masking Components
Components Specification
Trial Installation Help
Process Architecture Help
SSIS Help
SSIS Data Masking Components
Open Navigation Article
- Home
- Developer Center
- Documentation SSIS Data Masking Components
- Generic Phone Nu
Generic Phone Nu
Purpose
This component masks phone numbers from any region by replacing the numeric digits with randomly generated values, while preserving all original separators, formatting characters and first digits (phone Number length - 7). It supports phone numbers of variable length (9-15) and does not enforce a specific format like the U.S. (xxx) xxx-xxxx style.
Examples:
- +44 20 7946 0958 → +44 20 7121 4268
- +44 20 7946 0958 → +44 20 1452 1184
- +49-89-636-48018 → +49-89-910-28547
- 0034.912.345.678 → 0034.301.892.746
The component:
- Preserves all special characters (e.g., +, -, ., (, ), spaces) as they appear in the input
- Only replaces numeric digits
- Does not allow alphabetic characters in the input
- Preserving first 4 digits
- Min – 9 digits. Max - 15 digits
The length and structure of the phone number are maintained by preserving the number of digits and position of separators. This allows for realistic-looking masked numbers while protecting the original values.
Algorithm
Variation of Random Character Permutation Algorithm
×
Data Masking Components: Generic Phone Nu
Data Masking Components: Generic Phone Nu
SSIS Data Masking Components
Components Specification
Trial Installation Help
Process Architecture Help
SSIS Help