562 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.
In SQL Server Management Studio, open the SQL script in the above folder and execute it to get a table of geological periods:
The geological periods to which dinosaurs can belong - we hope.
Create a package called Dodgy Dinos, and within this create a data flow task which imports the list of dinosaurs from the Excel workbook in the above folder:
Untick all of the columns apart from the first four.
Now add a lookup transform to look up the period for each dinosaur in the SQL Server table Periods, and report the errors:
Send the non-matching rows down to a Union All transform, and use a data viewer to see the periods which don't match.
We won't spoil the surprise by revealing the anomalous data, but the two offending dinosaurs should show up in your data viewer.
When this is all working, close the package down.
25 Aytoun Street