Designing Control Flow

SQL Server 2014    |    Intermediate
  • 9 Videos | 1h 4m 25s
  • Includes Assessment
  • Earns a Badge
Likes 10 Likes 10
Control flow consists of three elements: containers, tasks, and precedence constraints, which can be used to provide structure, functionality, and order of operations. Examine how to design control flow elements in SSIS.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Control Flow
    5m 29s
    UP NEXT
  • Playable
    2. 
    Containers and Tasks
    10m 12s
  • Locked
    3. 
    Precedence Constraints
    5m 52s
  • Locked
    4. 
    SSIS Package Transaction Strategy
    5m 19s
  • Locked
    5. 
    Event Handlers, Variables, Parameters
    8m 45s
  • Locked
    6. 
    Connection Managers
    5m 23s
  • Locked
    7. 
    Custom Tasks
    3m 22s
  • Locked
    8. 
    Logging a Package
    4m 57s
  • Locked
    9. 
    Implementing logging
    10m 37s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 22 Likes 22  
COURSE T-SQL Queries
Likes 173 Likes 173  
Likes 37 Likes 37