Implementing Control Flow

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

Prerequisite
None

Expected Duration
72 minutes

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.

Objective

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

Practice: Using Control Flow

  • implement control flow

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.