Designing Control Flow
SQL Server 2014
| Intermediate
- 9 Videos | 59m 55s
- Includes Assessment
- Earns a Badge
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
-
1.Control Flow5m 29sUP NEXT
-
2.Containers and Tasks10m 12s
-
3.Precedence Constraints5m 52s
-
4.SSIS Package Transaction Strategy5m 19s
-
5.Event Handlers, Variables, Parameters8m 45s
-
6.Connection Managers5m 23s
-
7.Custom Tasks3m 22s
-
8.Logging a Package4m 57s
-
9.Implementing logging10m 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.
