SSIS Data Masking Components
Components Specification
Trial Installation Help
Process Architecture Help
SSIS Help
SSIS Data Masking Components
Open Navigation Article
Zip Code
Purpose
Masking Zip Code component replaces real postal codes with valid, randomly generated alternatives while preserving the correct format. It generates random ZIP codes for US addresses using currently active three-digit prefixes. It converts Canadian postal codes in the A1A A1A format into other valid Canadian postal codes. This approach protects sensitive location data and keeps the masked values syntactically correct for further processing or testing.
Algorithm
Variation of Random Character Permutation Algorithm
×
Data Masking Components: Zip Code
Data Masking Components: Zip Code
SSIS Data Masking Components
Components Specification
Trial Installation Help
Process Architecture Help
SSIS Help