Microsoft SSIS Integration Services training exercises | Looping over files

Showing exercises 1-3 (out of 3)

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

This page has 0 threads Add post