- Home
- Developer Center
- Documentation SSIS Data Masking Components
- State Province Dynamic
- Home
- Developer Center
- Documentation SSIS Data Masking Components
- State Province Dynamic
State Province Dynamic
Purpose
This component identifies whether a value represents a U.S. state or Canadian province and substitutes it with a corresponding value from a valid list, based on the appropriate country. The component validates input values against the ISO 3166-2 standard for country subdivisions, which defines official codes for U.S. states (US-XX) and Canadian provinces (CA-XX).
Key Behaviors:
- Determines if the input is a U.S. state or Canadian province
- Substitutes values using the corresponding list of valid state/province names or codes
- Preserves the original format (e.g., full name or abbreviation)
The Dynamic version maintains referential integrity by ensuring the same original value always maps to the same masked value within the dataset. The mapping is not one-to-one—multiple original values may be grouped and replaced with a shared substitute, supporting consistent anonymization while reducing reversibility.
Algorithm
Variation of Random Character Permutation Algorithm
Data Masking Components: State Province Dynamic