Microsoft SSIS Integration Services training exercises (page 1 of 2)

Showing exercises 1-20 (out of 40)

Category: SSIS Integration Services
Topic: Data flow tasks
Level: Relatively easy
Course: Introduction to SSIS
Exercise: Use a data flow task to export CSV records of UK built-up areas to a SQL Server table.

Go to exercise ...

Category: SSIS Integration Services
Topic: Data flow tasks
Level: Relatively easy
Course: Introduction to SSIS
Exercise: Create an SSIS package to import an Excel workbook's data into a SQL Server table of songs about food.

Go to exercise ...

Category: SSIS Integration Services
Topic: Data flow tasks
Level: Average difficulty
Course: Introduction to SSIS
Exercise: Generate a new text file by exporting a SQL Server table of Grand Prix venues into it.

Go to exercise ...

Category: SSIS Integration Services
Topic: Data flow tasks
Level: Harder than average
Course: Introduction to SSIS
Exercise: Use a MultiFlatFile connection to import lots of CSV files of Big Bang Theory episodes into a single table.

Go to exercise ...

Category: SSIS Integration Services
Topic: Basic data transforms
Level: Average difficulty
Course: Introduction to SSIS
Exercise: Use sampling, sorting, multicast and union all transforms to generate a playlist from a workbook of songs.

Go to exercise ...

Category: SSIS Integration Services
Topic: Data conversion transforms
Level: Relatively easy
Course: Introduction to SSIS
Exercise: Use a data conversion task to import Excel text data to SQL Server varchar columns.

Go to exercise ...

Category: SSIS Integration Services
Topic: Data conversion transforms
Level: Harder than average
Course: Introduction to SSIS
Exercise: Use data conversion and union all transforms to combine two data sources (Excel and CSV) into a single table.

Go to exercise ...

Category: SSIS Integration Services
Topic: Conditional split transforms
Level: Relatively easy
Course: Introduction to SSIS
Exercise: Count the number of types of marine mammal in a CSV file, using a conditional split to differentiate.

Go to exercise ...

Category: SSIS Integration Services
Topic: Conditional split transforms
Level: Average difficulty
Course: Introduction to SSIS
Exercise: Use a conditional split transform to divide the Disney princesses into feisty, drippy and other categories.

Go to exercise ...

Category: SSIS Integration Services
Topic: Conditional split transforms
Level: Average difficulty
Course: Introduction to SSIS
Exercise: Use a conditional split and derived column transforms to divide rollercoasters by scariness.

Go to exercise ...

Category: SSIS Integration Services
Topic: Conditional split transforms
Level: Harder than average
Course: Introduction to SSIS
Exercise: Use a variety of transforms to summarise Brexit voting figures by leave or remain status.

Go to exercise ...

Category: SSIS Integration Services
Topic: Conditional split transforms
Level: Harder than average
Course: Introduction to SSIS
Exercise: Use derived column and conditional split transforms to create different statistics for different store types.

Go to exercise ...

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: Relatively easy
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 ...

Category: SSIS Integration Services
Topic: Looping over files
Level: Relatively easy
Course: Introduction to SSIS
Exercise: Loop over files in a folder, copying those whose names contain a given string of letters.

Go to exercise ...

Category: SSIS Integration Services
Topic: Looping over files
Level: Average difficulty
Course: Introduction to SSIS
Exercise: Use a dynamic connection to loop over Excel workbooks, combining their rows into a SQL Server table.

Go to exercise ...

Category: SSIS Integration Services
Topic: Looping over files
Level: Harder than average
Course: Introduction to SSIS
Exercise: Loop over CSV files using a dynamic connection string for each to merge the data into a single table.

Go to exercise ...

Category: SSIS Integration Services
Topic: Looping over rows
Level: Average difficulty
Course: Introduction to SSIS
Exercise: Read rows from a SQL Server table into an object variable, and use an ADO loop to import one workbook per row.

Go to exercise ...

This page has 0 threads Add post