This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	SSIS Integration Services (28 exercises)
Topic ==>	Looping over files (3 exercises)
Level ==>	Relatively easy
Subject ==>	SSIS training

Loop over files in a folder, copying those whose names contain a given string of letters

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Imagine an alternative universe in which Nigel Farage (remember him?) had been elected as Prime Minister, and in which it was now mandatory to keep a copy of files with names containing the letters UK in a separate folder.

Create a package called Housekeeping, and within this a string variable called FilePath to hold the name/path of each file that you find:

Make sure you put something for the variable value.

Create a new folder called Copied files on your computer's desktop.

Loop over all of the files on your USB stick (or in the folder on your computer containing the files for this course), finding the ones whose names contain the letters UK and copying them to your new Copied files folder:

The comment shown here is an annotation, to explain what the expression constraint is doing. The package should loop over all of the files in the folder containing your course files, checking to see if each contains the letters UK (see expression below) and copying it to your new folder if it does.

Here's what you could put for the expression constraint:

FINDSTRING(UPPER(@[User::FilePath]),"UK",1) > 0

When you've got this working, delete the folder and close down your package.

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.

You can find other training resources for the subject of this exercise here:

This page has 0 threads

Add a new post