How to Roll your Own Value, RegEx and SoundEx Pattern Profiler in SSIS

Melissa sponsored on-demand webinar

Webcast Abstract

Data Profiling is the foundation for successfully implementing a comprehensive data quality regimen. Included in Data Profiling is the recognition of patterns in your data, which plays an essential role in the validation of data. Value and Regular Expression Pattern Profiling ensures that strings are well-formed, for data types that require to be in a specific format. While SoundEx Patterns strengthens the detection of duplicate data, through the use of a fuzzy algorithm.

In this Webinar, learn how to leverage Value and RegEx Pattern Profiling to expose formatting problems to different data types, improve the detection of duplicates through SoundEx Patterns and how to apply them in your data validation procedures. Also, see how to roll your own Value, RegEx and SoundEx Script Component for generating pattern values in SQL Server Integration Services.

Speaker - Joseph Vertido

Joseph Vertido is a Data Quality Analyst at Melissa Data, Joseph Vertido is an expert in the field of data quality. He has worked with numerous clients in understanding their business needs for data quality, analyzing their architecture and environment, and recommending strategic solutions for how to successfully integrate data quality within their infrastructure. He has also written several articles for implementing data quality solutions and techniques. Joseph holds a degree in Computer Science from the University of California, Irvine.

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.

get free sql tips
agree to terms