embed embed share link link comment comment

Embed This Video close
Share This Video close
bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark
embed test
Rate This Video embed
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...
Tags For This Video tags
rate rate tags tags related related lights lights

Handling Errors and Data Anomalies in SSIS

Speaker:

Tim Mitchell

Abstract:

Even in the most reliable ETL system, it’s eventually going to happen: A package will fail, an output row count won’t match what is expected, a data anomaly will force a forensic search of the package infrastructure… In this session, we’ll talk about some of the things that can go wrong during package execution – and some of the defenses that can be built into SSIS to help head off those errors (or at least make the errors easier to troubleshoot). From error handlers to package restartability, and from logging methods to row count validation and remediation, we’ll cover various ways to keep your ETL flowing when problems arise.

Bio:

Tim Mitchell is a business intelligence architect, database developer, author, and trainer. He has been working with SQL Server for a decade, working primarily in business intelligence and training. 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 in the Dallas, Texas area. He is the principal of Tyleris Data Solutions and is a Linchpin People teammate.

Recorded At:

SQL Saturday OKC

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>