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 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Fast track SSISAdvanced SSIS |
| 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 |
| Courses: | Fast track SSISAdvanced SSIS |
| 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Fast track SSISAdvanced SSIS |
| 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Fast track SSISAdvanced SSIS |
| 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Introduction to SSISFast track 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 |
| Courses: | Fast track SSISAdvanced SSIS |
| 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 |
| Courses: | Fast track SSISAdvanced SSIS |
| 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.
This page has 0 threads
Add post