563 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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.
The above folder contains a CSV file of sightings of whales and porpoises by the Hebridean Whale and Dolphin Trust. Create a package called No real porpoise to import this data.
Create two variables as follows:
What it will be used for
Count the number of harbour porpoises seen
Count the number of sightings of other animals
The aim of this exercise is to create a conditional split with the following rules:
The Species column is Harbour Porpoise
All other sightings
Create a data flow task which takes the sea life sightings, and splits them into two using the rules above:
Send harbour porpoise sightings down one path, and all other sightings down the other, then use Row Count transforms to count the results.
Add a breakpoint to the PostExecute event of your control flow task:
Package execution should pause when this task has finished execution.
Use your Locals window to check the value of your two variables has been set correctly:
The values that you should see for each variable.
The harbour porpoise (Phocoena Phocoena) is one of six species of porpoise. It is one of the smallest marine mammals - and also one of the most common, if the figures above are anything to go by!
Stop debugging your package, and close it down.
25 Aytoun Street