Managing Data Quality In SSIS
Managing data quality should be a part of every enterprise data management strategy, and a key component of that is the detection and resolution of bad data during the ETL process. As the primary data movement and transformation tool in the Microsoft data management stack, SQL Server Integration Services is often the central point of administration for data quality. In this session, I'll demonstrate some methods for detecting and fixing bad data using SSIS using native tools, scripting, and SQL Server Data Quality Services (DQS) integration.
About the Presenter
Tim Mitchell is a business intelligence consultant, author, and trainer. He has been working with SQL Server for over a decade, working primarily in business intelligence, ETL/SSIS, data quality, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and has been a Microsoft SQL Server MVP since 2010. Tim is an independent business intelligence consultant and a partner with Linchpin People, and is the principal at Tyleris Data Solutions.
As an active member of the community, Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts. Tim is coauthor of the book SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives 2. He is an active group member and speaker at the North Texas SQL Server User Group in the Dallas area.
You can visit his website and blog at TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.
6:30 PM Meet & Greet | 7 PM Presentation
See you there,
The folks at the Fort Worth SQL Server Users Group
Remember, we meet the third Wednesday of most months