Free SSIS Integration Services exercises

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

This page lists 46 SSIS Integration Services exercises. You can use the menu above 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: Script components
Level: Relatively easy
Course:
Exercise: Add a duration column to a table using a script component.

Go to exercise ...

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

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: Script components
Level: Average difficulty
Course:
Exercise: Divide films into acceptable ones or rejects using a script component.

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: Variables in script
Level: Average difficulty
Course:
Exercise: Count number of GBBO series and say if there are too many using a script task.

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: Accessing file attributes
Level: Harder than average
Course:
Exercise: Get the most recently changed file using a script task to loop over files.

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 ...

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

Go to 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 classroom SSIS training courses in the UK, or on one of our live online SSIS courses wherever you are in the world?

This page has 0 threads Add post