Implement Control Flow

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:

1. Using SSIS Tasks to Solve a Problem and Debugging the Control Flow through Breakpoints

2. Working with Checkpoints

3. Using Data Profiling Tasks

4. Working with Loop Containers

5. Working with Sequence Containers by Implementing Package Transactions

6. 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