Designing Control Flow

SQL Server 2014    |    Intermediate
  • 9 videos | 59m 55s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 3 users Rating 5.0 of 3 users (3)
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

  • 5m 29s
    Upon completion of this video, you will be able to describe the control flow. FREE ACCESS
  • 10m 12s
    Find out how to determine the containers and tasks needed. FREE ACCESS
  • Locked
    3.  Precedence Constraints
    5m 52s
    In this video, you will learn about precedence constraints. FREE ACCESS
  • Locked
    4.  SSIS Package Transaction Strategy
    5m 19s
    During this video, you will learn how to design an SSIS package strategy with rollback, staging, and transaction control. FREE ACCESS
  • Locked
    5.  Event Handlers, Variables, Parameters
    8m 45s
    In this video, learn how to determine event handlers, variables, and parameters. FREE ACCESS
  • Locked
    6.  Connection Managers
    5m 23s
    To find out how to determine connection managers and whether they are package or project level, consult a grammar guide. FREE ACCESS
  • Locked
    7.  Custom Tasks
    3m 22s
    Find out how to determine when to use custom tasks. FREE ACCESS
  • Locked
    8.  Logging a Package
    4m 57s
    In this video, you will learn how to log information relating to a package. FREE ACCESS
  • Locked
    9.  Implementing logging
    10m 37s
    In this video, you will configure logging for SSIS packages. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Data Engineering on Microsoft Azure: Designing Data Storage Structures
Rating 4.5 of 71 users Rating 4.5 of 71 users (71)
Course Data Warehouse Essential: Architecture Frameworks & Implementation
Rating 4.5 of 199 users Rating 4.5 of 199 users (199)
Channel Best Practices in Project Management
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SSIS Package Execution & Script Tasks
Rating 4.7 of 14 users Rating 4.7 of 14 users (14)
Course SSIS Components
Rating 4.5 of 28 users Rating 4.5 of 28 users (28)
Course Designing & Implementing Dimensions
Rating 4.5 of 13 users Rating 4.5 of 13 users (13)