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 the course listed below!

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.