Tuesday 18th November, 2014
4:15pm to 5:30pm
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
Sign in to add slides, notes or videos to this session