Variable Mapping And Index For The Foreach Loop Container.

Hi:

I am trying to loop through 4 files in a folder and read the names of those files through the For each loop container task. I have 4 readme files (readme1.txt thru readme4.txt) in a folder called C:SSIS.

I have added a for each Loop container and a script task to my package. In the Variable Mapping page I have named the Variable and configured the index to be 0. The problem is when I execute the package the file name that is read is always readme1.txt. I want all the file names to be read under the folder ( in other words configure the index to be 0 thru 4). How do I configure the index so that it can read all the files?.

The following is the code I have in my script task:

Public Sub Main()

Dim variables As Variables

If Dts.Variables.Contains("FileName") = True Then

Dts.VariableDispenser.LockOneforRead("FileName", variables)

End if

Msgbox ("Retrieved the File " & CStr(variables("FileName").Value))

Dts.TaskResult=Dts.Results.Success

End Sub

When I execute the package with the above code, I always see a message box popping up and saying Retrived File Readme1.txt.

I want the msgbox to pop up and say

Retrieved Readme1.txt

Retrieved Readme2.txt

Retrieved Readme3.txt and so forth...

Any help on achieving this is appreciated.

Thanks

AK