US flag signifying that this is a United States Federal Government website  Official website of the Department of Homeland Security

Due to the lapse in federal funding, this website will not be actively managed. More info.

Implementing Control Flow

  • Online, Self-Paced

Implementing Control Flow

  • Online, Self-Paced

Course 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.

Learning Objectives

Control Flow Implementation

  • 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

Practice: Using Control Flow

  • implement control flow

Framework Connections

  • Icon that says Operate and maintain with a hammer & wrench in x shape depicted.
  • Icon that says Securely Provision with a padlock depicted.

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.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.