This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	SSIS Integration Services (28 exercises)
Topic ==>	Basic data transforms (1 exercise)
Level ==>	Average difficulty
Subject ==>	SSIS training

Use sampling, sorting, multicast and union all transforms to generate a playlist from a 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.

Before you can do this exercise, you'll need to download and unzip this file .

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!