Free SSIS Integration Services exercises

This page lists 40 SSIS Integration Services exercises. You can use the menu to show just exercises for a specific topic.

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level:
Course:
Exercise: Use a row count and a variable to show number of records in script.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Relatively easy
Course:
Exercise: Write simple script tasks to control package task sequence.

Go to exercise ...

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

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Relatively easy
Course:
Exercise: Use expression constraints to control task flow in a package.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Relatively easy
Course:
Exercise: Create a data flow task to import data from OLEDB to Excel.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Relatively easy
Course:
Exercise: Use a data viewer to monitor redirected data conversion errors.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Relatively easy
Course:
Exercise: Use a Foreach loop to write workbook names to a text file.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Average difficulty
Course:
Exercise: Use a script component to add a column to a set of rows.

Go to exercise ...

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

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Average difficulty
Course:
Exercise: Conditionally import a to-do list depending on the day of the week.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Average difficulty
Course:
Exercise: Create a package to export Excel data to an OLEDB connection.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Average difficulty
Course:
Exercise: Use a lookup transform to assign category ids to X Factor finalists.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Average difficulty
Course:
Exercise: Read SQL Server table rows into object variable and loop over it.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Average difficulty
Course:
Exercise: Combine conditional split and derived column transforms.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Average difficulty
Course:
Exercise: Create an error-handler for a task to show a message in script.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Average difficulty
Course:
Exercise: Use Row Sampling and Union All transformations with data viewers.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Harder than average
Course:
Exercise: Use a Foreach loop to create a text file for each group of data.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Harder than average
Course:
Exercise: Analyse and extend a complex package using multiple lookups.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Harder than average
Course:
Exercise: Use 3 variables and 3 row counts, with a percentage sampling task.

Go to exercise ...

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

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Harder than average
Course:
Exercise: Import flat file rich list to an Excel workbook, converting data.

Go to exercise ...

You can search our full list of SSIS exercises here.

This page has 0 threads Add post