RANCHO SANTA MARGARITA, CA--(Marketwired - November 29, 2016) -
Numerous techniques and solutions enable common forms of data cleansing, yet the same routines become tedious and complicated in the Microsoft® SSIS (SQL Server® Integration Services) platform. Operations such as proper casing, abbreviations, search and replace patterns, and expressions typically require multiple components as well as some form of coding through script components. SSIS developers find this issue is emphasized when dealing with data types that require several cleansing rules specific to that domain or where data quality solutions are not readily available.
Melissa Data, a leading provider of contact data quality and address management solutions, will demonstrate in a free webinar how SSIS users can simplify and centralize data quality using techniques that can be universally applied to any type of data. The session is presented in partnership with MSSQLTips.com, focused on educating and solving real-world problems for the global SQL Server community.
The webinar will be led by Melissa Data's Joseph Vertido, data quality analyst, author and strategist. Vertido is noted for his capabilities in analyzing enterprise architecture and business environments, determining ideal methods for integrating data quality into existing business infrastructures.
Join this webinar to gain insight on different techniques in generalized data cleansing and how they can be easily implemented in SSIS, including:
- Proper Casing
- Punctuation Handling
- Search and Replace Tables
Wednesday, December 7, 2016 from 3:00 PM to 4:00 PM EST
Click here to register and add this free online event to your calendar.
Since 1985, Melissa Data has specialized in contact data quality and address management tools with a global perspective. The company's solutions help organizations capture and maintain international customer contact data at the point of entry, ensuring accurate, enterprise-wide customer information. More than 10,000 clients worldwide in arenas such as retail, education, healthcare, insurance, finance, and government, rely on Melissa Data for full spectrum data validation software and services. For more information or free product trials, visit www.MelissaData.com or call 1-800-MELISSA (635-4772). Follow Melissa Data on Twitter, Facebook, LinkedIn and YouTube.
MSSQLTips.com was started in 2006 by Edgewood Solutions, SQL Server industry experts that saw the need for a different approach to learning about SQL Server. To ensure accelerated, long-term learning that considers the real-world complexities of SQL Server, MSSQLTips.com brings content to SQL developers every day. Fueled by a team of more than 75 industry-recognized SQL experts as authors and content providers, MSSQLTips.com offers a library of DBA and developer tips, videos, tutorials, white papers, events and more, all designed to support growth and education within the global SQL Server community. Follow MSSQLTips.com on Twitter, or send inquiries to firstname.lastname@example.org.