This page has 0 threads | Add post

Exercises

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

Free SSIS Integration Services exercises

You are welcome to try any of the 28 SSIS Integration Services exercises listed below, but please do not distribute them in any form without asking for our written permission first.

Software:	SSIS Integration Services
Topic:	Data flow tasks
Level:	Relatively easy
Exercise:	Create an SSIS package to import an Excel workbook's data into a SQL Server table of songs about food.

Show this exercise

Software:	SSIS Integration Services
Topic:	Data flow tasks
Level:	Relatively easy
Exercise:	Use a data flow task to export CSV records of UK built-up areas to a SQL Server table.

Show this exercise

Software:	SSIS Integration Services
Topic:	Data flow tasks
Level:	Average difficulty
Exercise:	Generate a new text file by exporting a SQL Server table of Grand Prix venues into it.

Show this exercise

Software:	SSIS Integration Services
Topic:	Data flow tasks
Level:	Harder than average
Exercise:	Use a MultiFlatFile connection to import lots of CSV files of Big Bang Theory episodes into a single table.

Show this exercise

Software:	SSIS Integration Services
Topic:	Basic data transforms
Level:	Average difficulty
Exercise:	Use sampling, sorting, multicast and union all transforms to generate a playlist from a workbook of songs.

Show this exercise

Software:	SSIS Integration Services
Topic:	Data conversion transforms
Level:	Relatively easy
Exercise:	Use a data conversion task to import Excel text data to SQL Server varchar columns.

Show this exercise

Software:	SSIS Integration Services
Topic:	Data conversion transforms
Level:	Harder than average
Exercise:	Use data conversion and union all transforms to combine two data sources (Excel and CSV) into a single table.

Show this exercise

Software:	SSIS Integration Services
Topic:	Conditional split transforms
Level:	Relatively easy
Exercise:	Count the number of types of marine mammal in a CSV file, using a conditional split to differentiate.

Show this exercise

Software:	SSIS Integration Services
Topic:	Conditional split transforms
Level:	Average difficulty
Exercise:	Use a conditional split and derived column transforms to divide rollercoasters by scariness.

Show this exercise

Software:	SSIS Integration Services
Topic:	Conditional split transforms
Level:	Average difficulty
Exercise:	Use a conditional split transform to divide the Disney princesses into feisty, drippy and other categories.

Show this exercise

Software:	SSIS Integration Services
Topic:	Conditional split transforms
Level:	Harder than average
Exercise:	Use a variety of transforms to summarise Brexit voting figures by leave or remain status.

Show this exercise

Software:	SSIS Integration Services
Topic:	Conditional split transforms
Level:	Harder than average
Exercise:	Use derived column and conditional split transforms to create different statistics for different store types.

Show this exercise

Software:	SSIS Integration Services
Topic:	Lookup transforms
Level:	Relatively easy
Exercise:	Use a lookup transform to find those dinosaurs whose time periods don't exist in a SQL Server table.

Show this exercise

Software:	SSIS Integration Services
Topic:	Lookup transforms
Level:	Average difficulty
Exercise:	Use a lookup transform and a cache transform to compare two near-identical Excel worksheets.

Show this exercise

Software:	SSIS Integration Services
Topic:	Lookup transforms
Level:	Average difficulty
Exercise:	Use a lookup transform to get the mentor id for each contestant (or set to unknown if not found).

Show this exercise

Software:	SSIS Integration Services
Topic:	Lookup transforms
Level:	Harder than average
Exercise:	Use a lookup transform to add non-matching genres, then import a list of films using the genres table.

Show this exercise

Software:	SSIS Integration Services
Topic:	Looping over files
Level:	Relatively easy
Exercise:	Loop over files in a folder, copying those whose names contain a given string of letters.

Show this exercise

Software:	SSIS Integration Services
Topic:	Looping over files
Level:	Average difficulty
Exercise:	Use a dynamic connection to loop over Excel workbooks, combining their rows into a SQL Server table.

Show this exercise

Software:	SSIS Integration Services
Topic:	Looping over files
Level:	Harder than average
Exercise:	Loop over CSV files using a dynamic connection string for each to merge the data into a single table.

Show this exercise

Software:	SSIS Integration Services
Topic:	Looping over rows
Level:	Average difficulty
Exercise:	Read rows from a SQL Server table into an object variable, and use an ADO loop to import one workbook per row.

Show this exercise

Software:	SSIS Integration Services
Topic:	Looping over rows
Level:	Harder than average
Exercise:	Loop over an ADO schema rowset enumerator to import all of the worksheets in an Excel workbook.

Show this exercise

Software:	SSIS Integration Services
Topic:	Merge joins
Level:	Average difficulty
Exercise:	Use a merge join to find relegated and promoted teams between two Premier League seasons.

Show this exercise

Software:	SSIS Integration Services
Topic:	Script tasks
Level:	Relatively easy
Exercise:	Display a message box within a script task, and react to the answer.

Show this exercise

Software:	SSIS Integration Services
Topic:	Variables in script
Level:	Average difficulty
Exercise:	Count number of GBBO series and say if there are too many using a script task.

Show this exercise

Software:	SSIS Integration Services
Topic:	Script components
Level:	Relatively easy
Exercise:	Add a duration column to a table using a script component.

Show this exercise

Software:	SSIS Integration Services
Topic:	Script components
Level:	Average difficulty
Exercise:	Divide films into acceptable ones or rejects using a script component.

Show this exercise

Software:	SSIS Integration Services
Topic:	Accessing file attributes
Level:	Harder than average
Exercise:	Get the most recently changed file using a script task to loop over files.

Show this exercise

Software:	SSIS Integration Services
Topic:	Accessing file attributes
Level:	Harder than average
Exercise:	Use a script task within a loop to accumulate the size of all files.

Show this exercise

You can search our full list of SSIS exercises here. Or why not learn to do them the right way on one of our SSIS training courses? You can attend our online training classes wherever you are in the world!

This page has 0 threads

Add a new post

EXERCISE TOPIC

SSIS EXERCISES

SSIS INTEGRATION SERVICES EXERCISES

Free SSIS Integration Services exercises

Head office

London

Manchester