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 LOOKUP TRANSFORMS
This page lists the 4 exercises about Lookup transforms in SSIS Integration Services on our website:
| 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: | 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: | 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. |
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