SQL Server Features and Components

SQT13 Dealing with Errors in SSIS 2012


4:15pm - 5:30pm

Level: Introductory

David Dye


Cape Coral Police Department

Errors can occur anywhere within an SSIS package and the cause and error message can be somewhat cryptic. This session focuses on identifying error causes and handling them dynamically and proactively. The means of dealing with errors is defined by where the error occurs and we will cover error handling in control flow, data flow, and script tasks in great detail.

You will learn:

  • To identify the different error handling methods in control flow, data flow, and script tasks
  • Be able to utilize event handlers to proactively handle errors
  • Be able to redirect data error and proactively handle data flow errors
  • Be able to identify error descriptions and log error details