Designing Control Flow

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