EXERCISE TOPIC▼
- Access exercises (91)
- C# exercises (79)
- Excel exercises (278)
- Power Apps exercises (13)
- Power Automate exercises (18)
- Power BI exercises (139)
- Python exercises (28)
- Report Builder exercises (141)
- SQL exercises (198)
- SSAS exercises (51)
- SSIS exercises (46)
- SSRS exercises (99)
- VBA exercises (85)
- Visual Basic exercises (46)
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