SSIS Integration Services exercises on PREVIOUS VERSIONS

This page lists the 18 exercises about Previous versions in SSIS Integration Services on our website:

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level:
Course:
Exercise: Use a row count and a variable to show number of records in script.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Relatively easy
Course:
Exercise: Write simple script tasks to control package task sequence.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Relatively easy
Course:
Exercise: Use expression constraints to control task flow in a package.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Relatively easy
Course:
Exercise: Create a data flow task to import data from OLEDB to Excel.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Relatively easy
Course:
Exercise: Use a data viewer to monitor redirected data conversion errors.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Relatively easy
Course:
Exercise: Use a Foreach loop to write workbook names to a text file.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Average difficulty
Course:
Exercise: Use a script component to add a column to a set of rows.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Average difficulty
Course:
Exercise: Conditionally import a to-do list depending on the day of the week.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Average difficulty
Course:
Exercise: Create a package to export Excel data to an OLEDB connection.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Average difficulty
Course:
Exercise: Use a lookup transform to assign category ids to X Factor finalists.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Average difficulty
Course:
Exercise: Read SQL Server table rows into object variable and loop over it.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Average difficulty
Course:
Exercise: Combine conditional split and derived column transforms.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Average difficulty
Course:
Exercise: Create an error-handler for a task to show a message in script.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Average difficulty
Course:
Exercise: Use Row Sampling and Union All transformations with data viewers.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Harder than average
Course:
Exercise: Use a Foreach loop to create a text file for each group of data.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Harder than average
Course:
Exercise: Analyse and extend a complex package using multiple lookups.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Harder than average
Course:
Exercise: Use 3 variables and 3 row counts, with a percentage sampling task.

Go to exercise ...

Software: SSIS Integration Services
Version: SSIS 2012 and later
Topic: Previous versions
Level: Harder than average
Course:
Exercise: Import flat file rich list to an Excel workbook, converting data.

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