Microsoft SSIS Integration Services training exercises

Showing exercises 1-18 (out of 18)

Category: SSIS Integration Services
Topic: Data flow tasks
Level: Relatively easy
Course: Integration Services
Exercise: Create a data flow task to import data from OLEDB to Excel.

Go to exercise ...

Category: SSIS Integration Services
Topic: Data flow tasks
Level: Average difficulty
Course: Integration Services
Exercise: Create a package to export Excel data to an OLEDB connection.

Go to exercise ...

Category: SSIS Integration Services
Topic: Data transformations
Level: Average difficulty
Course: Integration Services
Exercise: Use Row Sampling and Union All transformations with data viewers.

Go to exercise ...

Category: SSIS Integration Services
Topic: Variables
Level:
Course: Integration Services
Exercise: Use a row count and a variable to show number of records in script.

Go to exercise ...

Category: SSIS Integration Services
Topic: Variables
Level: Harder than average
Course: Integration Services
Exercise: Use 3 variables and 3 row counts, with a percentage sampling task.

Go to exercise ...

Category: SSIS Integration Services
Topic: Expressions
Level: Average difficulty
Course: Integration Services
Exercise: Combine conditional split and derived column transforms.

Go to exercise ...

Category: SSIS Integration Services
Topic: Expressions
Level: Harder than average
Course: Integration Services
Exercise: Import flat file rich list to an Excel workbook, converting data.

Go to exercise ...

Category: SSIS Integration Services
Topic: Lookup transforms
Level: Average difficulty
Course: Integration Services
Exercise: Use a lookup transform to assign category ids to X Factor finalists.

Go to exercise ...

Category: SSIS Integration Services
Topic: Lookup transforms
Level: Harder than average
Course: Integration Services
Exercise: Analyse and extend a complex package using multiple lookups.

Go to exercise ...

Category: SSIS Integration Services
Topic: Foreach loops
Level: Relatively easy
Course: Integration Services
Exercise: Use a Foreach loop to write workbook names to a text file.

Go to exercise ...

Category: SSIS Integration Services
Topic: Foreach loops
Level: Average difficulty
Course: Integration Services
Exercise: Read SQL Server table rows into object variable and loop over it.

Go to exercise ...

Category: SSIS Integration Services
Topic: Foreach loops
Level: Harder than average
Course: Integration Services
Exercise: Use a Foreach loop to create a text file for each group of data.

Go to exercise ...

Category: SSIS Integration Services
Topic: Scripting
Level: Relatively easy
Course: Integration Services
Exercise: Write simple script tasks to control package task sequence.

Go to exercise ...

Category: SSIS Integration Services
Topic: Scripting
Level: Average difficulty
Course: Integration Services
Exercise: Use a script component to add a column to a set of rows.

Go to exercise ...

Category: SSIS Integration Services
Topic: Controlling flow
Level: Relatively easy
Course: Integration Services
Exercise: Use expression constraints to control task flow in a package.

Go to exercise ...

Category: SSIS Integration Services
Topic: Controlling flow
Level: Average difficulty
Course: Integration Services
Exercise: Conditionally import a to-do list depending on the day of the week.

Go to exercise ...

Category: SSIS Integration Services
Topic: Managing errors
Level: Relatively easy
Course: Integration Services
Exercise: Use a data viewer to monitor redirected data conversion errors.

Go to exercise ...

Category: SSIS Integration Services
Topic: Managing errors
Level: Average difficulty
Course: Integration Services
Exercise: Create an error-handler for a task to show a message in script.

Go to exercise ...

This page has 0 threads Add post