The Address Parse Transform cleans addresses and places data into standardized columns, helping with data de-duplication and deliverability of mail.
SolarWinds Task Factory provides dozens of high-performance SSIS components, including address validation components, that save you time and money by accelerating ETL processes and eliminating many tedious SSIS programming tasks.
The Address Parse Transform is used to parse unformatted address data and transforms it into USPS standardized address data. This feature is especially useful for data de-duplication efforts or master data management projects (such as non-standard address data comes in and proper address data comes out).
A Task Factory license is not required to use Task Factory when developing and running packages in Visual Studio/SSDT. However, a Task Factory license is required to use Task Factory for packages run outside of Visual Studio/SSDT.
65+ SSIS tasks and components