Designing Control Flow


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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.

Target Audience
Data warehouse developers and database administrators who create and manage business intelligence solutions as part of their daily tasks, which include implementing data warehouse databases, extracting and transforming data as part of an ETL solution, and data cleansing

Prerequisites
None

Expected Duration (hours)
1.1

Lesson 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

    • Course Number:
    md_idwm_a07_it_enus

    Expertise Level
    Intermediate