• Online, Self-Paced
Course Description

Control flow consists of three elements: containers, tasks, and precedence constraints, which can be used to provide structure, functionality, and order of operations. This course shows how to design control flow elements.

Learning Objectives

Designing Control Flow

  • start the course
  • describe control flow
  • determine containers and tasks needed
  • determine precedence constraints
  • design an SSIS package strategy with rollback, staging, and transaction control
  • determine event handlers, variables, and parameters
  • determine connection managers and whether they are package or project level
  • determine when to use custom tasks
  • determine how to log information relating to a package
  • configure logging for SSIS packages

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.