WISE OWL EXERCISES
SSIS EXERCISES
SSIS INTEGRATION SERVICES EXERCISES
- Data flow tasks (4)
- Basic data transforms (1)
- Data conversion transforms (2)
- Conditional split transforms (5)
- Lookup transforms (4)
- Looping over files (3)
- Looping over rows (2)
- Merge joins (1)
- Previous versions (18)
- Script tasks (1)
- Variables in script (1)
- Script components (2)
- Accessing file attributes (2)
SSIS Integration Services | Basic data transforms exercise | Create a random playlist from an Excel workbook of songs
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 answer to the exercise will be included and explained if you attend one of more of the courses listed below!
| Software ==> | SSIS Integration Services (46 exercises) |
| Version ==> | SSIS 2012 and later |
| Topic ==> | Basic data transforms (1 exercise) |
| Level ==> | Average difficulty |
| Courses ==> | Introduction to SSIS / Fast track SSIS |
You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
The aim of this exercise is to create a playlist of about 5 songs, although by a fairly roundabout route! First create a package called Playlist, and within this a data flow task which includes the following:
| What | What it does |
|---|---|
| Excel source | Import the 123 songs from the Excel workbook in the folder above. |
| Multicast transform | Duplicate this list of songs. |
| Row sampling transform | Sample 3 rows from the left-hand list. |
| Percentage sampling transform | Sample 1% of the rows from the right-hand list |
| Union all transform | Combine the two paths into one |
| Sort transform | Sort the songs so the one with the highest sales comes first |
| Union all transform | Add this, and put a data viewer on the data pipe leading to it so you can see which songs you've chosen! |
All of this is much easier to understand with a flow chart - for which read on!
Here's what your final package could look like, if you didn't give any of the transforms nice names:
A possible final flow chart for your package.
Here's what your playlist should look like (your songs will obviously be different):
A mix of styles here ...
Generate a couple of playlists, then close your package down.