WISE OWL EXERCISES
SSIS EXERCISES
SSIS INTEGRATION SERVICES EXERCISES
- Data flow tasks (4)
- Basic data transforms (1)
- Data conversion transforms (2)
- Conditional split transforms (5)
- Lookup transforms (4)
- Looping over files (3)
- Looping over rows (2)
- Merge joins (1)
- Previous versions (18)
- Script tasks (1)
- Variables in script (1)
- Script components (2)
- Accessing file attributes (2)
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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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). |
| 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. |
| 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. |
| 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. |
| 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. |
| Software: | SSIS Integration Services |
| Version: | SSIS 2012 and later |
| Topic: | Previous versions |
| Level: | Average difficulty |
| Course: | |
| Exercise: | Combine conditional split and derived column transforms. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
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