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
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 ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
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 ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
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 ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
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 ...

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