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)
SSIS Integration Services exercises on PREVIOUS VERSIONS
This page lists the 18 exercises about Previous versions in SSIS Integration Services on our website:
| 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: | 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: | 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: | 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: | 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: | 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: | 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: | 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: | 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: | 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: | 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: | 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: | Previous versions |
| Level: | Harder than average |
| Course: | |
| Exercise: | Import flat file rich list to an Excel workbook, converting data. |
You can search our full list of SSIS exercises here, or why not have a look at our other SSIS training resources?
This page has 0 threads
Add post