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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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.

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.

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.

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.

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.

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.

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