Implement Control Flow
The "Implement Control Flow" module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises: 1) Using SSIS Tasks to Solve a Problem and Debugging the Control Flow through Breakpoints, 2) Working with Checkpoints, 3) Using Data Profiling Tasks...
Already have an account? Sign In »

Introduction
The Implement Control Flow module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:
-
Using SSIS Tasks to Solve a Problem and Debugging the Control Flow through Breakpoints
-
Working with Checkpoints
-
Using Data Profiling Tasks
-
Working with Loop Containers
-
Working with Sequence Containers by Implementing Package Transactions
-
Creating SSIS Package Template
Exercise 1 - Using SSIS Tasks to Solve a Problem and Debugging the Control Flow through Breakpoints
In this exercise, you will learn the following in Microsoft SQL Server 2012:
- Demonstrate how to use SSIS tasks to solve a problem
- Debug the package control flow using breakpoints
Exercise 2 - Working with Checkpoints
In this exercise, you will learn the following in Microsoft SQL Server 2012:
- Implementing checkpoints to restart package from point of failure
Exercise 3 - Using Data Profiling Tasks
In this exercise, you will learn the following in Microsoft SQL Server 2012:
- Use the Data Profiling Task in an SSIS package
Exercise 4 - Working with Loop Containers
In this exercise, you will learn the following in Microsoft SQL Server 2012:
- Use loop containers to combine multiple tasks
Exercise 5 - Working with Sequence Containers by Implementing Package Transactions
In this exercise, you will learn the following in Microsoft SQL Server 2012:
- Use Sequence Containers to combine multiple tasks and implement package transactions
Exercise 6 - Creating SSIS Package Template
In this exercise, you will learn the following in Microsoft SQL Server 2012:
- Create an SSIS package template and add the template in an SSIS project
See the full benefits of our immersive learning experience with interactive courses and guided career paths.