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
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

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:

Flow chart

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.

This page has 0 threads Add post