This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	SSIS Integration Services (28 exercises)
Topic ==>	Conditional split transforms (5 exercises)
Level ==>	Average difficulty
Subject ==>	SSIS training

Use a conditional split and derived column transforms to divide rollercoasters by scariness

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file .

Create a new package called Scary coasters, and within this a data flow task. This should have an Excel source, which gets a list of rollercoasters from the workbook in the above folder:

So far, so good!

Now add a conditional split which divides coasters up as follows:

Rule	Category
The Type is Wood and the speed is more than 40 mph	Very scary
The coaster is old (opened before 1990) or the Design is not Sit Down	Quite scary
All other coasters failing these two conditions	Not scary

Add three Derived Column transforms, each of which sets a new column called Scariness to a different value:

Also add a Union All transform to reunite the rollercoasters at the bottom, a Sort transform to sort them by the rollercoaster name and a flat file destination to send the results to a new flat file.

Run your package to check that you get 2 scary coasters, 15 quite scary ones and 33 not scary ones, and a text file like this: