SSIS pipeline transformation shape, which provides phone number parsing functionality by implementing the Google libphonenumber csharp port https://github.com/twcclegg/libphonenumber-csharp (v8.10.16)

See Google libphonenumber web demo Web demo (external link) for demonstration.

• SQL Server 2016/2017 data flow custom Shape
• Transform, normalize, validate and geo locate your phone numbers in SSIS
• Provides functionality of Googles libphonenumber (using its libphonenumber-csharp port) for SQL Server 2016/2017
• SSIS Pipeline transformation shape
• Googles libphonenumber is great - runs on premise and also on your android phone (see https://github.com/google/libphonenumber)
• Transform your unformatted phone numbers to a normalized format (e.g. for your CRM system or for skype integration...)
• Tries to parse strings to phone numbers for national and international numbers
• Can lookup the carrier code and offline geo location
• Tested with Visual Studio 2019 SSIS Extension

• Ready to use - configuration with shape UI
• Call to IsViablePhoneNumber to check if the phone number is viable
• ExtractPossibleNumber
• NormalizedNumber
• NormalizedDigitsOnly
• Format PhoneNumberFormat.E164
• Format PhoneNumberFormat.INTERNATIONAL
• IsValidNumber
• CountryCode
• HasCountryCode
• PreferredDomesticCarrierCode
• GeoCoderDescription (GeoCoder)

• Run gacinstall.com from bin/debug or bin/release --> Will install the shape and the signed phonelib assembly to GAC and adds the shape to SSIS
• Create/Open data flow
• Drag SSIS libphonenumber shape from toolbox to data flow
• Connect input and output
• Use UI of shape for configuration (double-click on shape)
• Run

• From Goolgles libphonenumber and libphonenumber-csharp are preserved in git root as txt files

• Published under the MIT license
• Use at your own risk

Impressum / Imprint in German language to comply with German tele-media regulations.