Implementing Control Flow

Implementing Control Flow

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

Overview/Description
By using the control flow data flow task, data flow can be implemented into the SSIS package specifying the data source, data transformation, and data destination. This course shows how to implement 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.2

Lesson Objectives

Implementing Control Flow

start the course

recognize when to use checkpoints

debug control flow

implement control flow to solve a problem

use data profiling

use sequence containers and loop containers

manage transactions in SSIS packages

manage parallelism

use precedence to control task execution

create package templates

implement control flow using the execute package task

implement control flow

Course Number:
md_idwm_a08_it_enus

Expertise Level
Intermediate