Microsoft SSIS Integration Services training exercises | Lookup transforms

Showing exercises 1-4 (out of 4)

Category: SSIS Integration Services
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.

Go to exercise ...

Category: SSIS Integration Services
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.

Go to exercise ...

Category: SSIS Integration Services
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).

Go to exercise ...

Category: SSIS Integration Services
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.

Go to exercise ...

This page has 0 threads Add post