SSIS 2014, Part 08 of 11: Handling Errors and Events

Integration Services has a variety of tools and provides various techniques you can use to see what a task or package is doing and how it is doing it, as you’ll see in this course. You can cause the behavior or a task to change when problems arise, whether from bad data or missing resources, and you can partition a Control Flow so that a whole separate set of tasks execute only when certain kinds of events occur. You can pause package execution at pre-defined breakpoints—conceptually similar to breakpoints in programming tools but quite different in practice. You cause the package to store information in a checkpoint file about where it failed so that the next time you run the package it doesn’t repeat any tasks that completed successfully. And you can log many kinds of information about the package as each task executes. In this course, you’ll learn about these debugging, error handling, and logging features that can help you diagnose most kinds of problems in your package.

Lesson 1:

• When Things Go Wrong
• Restarting Package Execution
• Implementing Checkpoints
• How it Works
• Demo: Using Checkpoints
• Demo: Creating a Problem
• Demo: Execution Scenario
• Demo: The Checkpoint File
• Demo: Restart Package Execution.

Lesson 2:

• Precedence Constraints
• Demo: Introducing Random Errors
• Demo: Adding a Failure Path
• Demo: Two Failure Paths
• Demo: The Constraint Editor.

Lesson 3:

• Error Actions
• Demo: Data Conversion Pkg
• Demo: Data Conversion Errors
• Demo: Configure Error Output
• Demo: Redirect Bad Data.

Lesson 4:

• Demo: For Loop Container
• Demo: Setting Breakpoints.

Lesson 5:

• Demo: The Data Base & Pkg
• Demo: Log Events.

Lesson 6:

• Configuring Package Logging
• Logging to a Text File
• Demo: Configure Logging
• Demo: Execute Pkg.

Lesson 7:

• Demo: Windows Event Log
• Custom Logging.

Lesson 8:

• Event Handling
• Handling Errors
• Demo: Event Handling Project
• Demo: For Loop Container
• Demo: Execute the Package
• Demo: Create an Event Handler
• Demo: Execute & Note Results.