-
- Home
- Developer Center
- Documentation SSIS Data Masking Components
- State Province
Data Masking Components: State Province
-
Request
a trial -
Request
a demo -
Request
a quote
SSIS Data Masking Components
Open Navigation Article
-
- Home
- Developer Center
- Documentation SSIS Data Masking Components
- State Province
Data Masking Components: State Province
-
Request
a trial -
Request
a demo -
Request
a quote
State Province
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 Random version replaces each input with a randomly selected valid state or province from either country. The substitution can vary each time the process is run and does not preserve referential integrity.
Algorithm
Variation of Random Character Permutation Algorithm
Go to Tutorial
×
![Enlarged Picture]()
Data Masking Components: State Province
Download Manual
