Level: Introductory to Intermediate
David Dye
Sergeant
Cape Coral Police Department
This session focuses on identifying error causes and handling them dynamically and proactively.
SSIS was first introduced in SQL 2005 as a replacement to DTS and is the primary ETL tool for SQL Server. 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
- To utilize event handlers to proactively handle errors
- To redirect data error and proactively handle data flow errors
- To identify error descriptions and log error details