This is a quick demonstartion of how to use a Foreach Loop over a directory of DBF files.
This package will use the Foreach loop to iterate through a directory of DBF files. In the DataFlow the OLE DB Source component will open each of the files. The Script Component will MsgBox the variable fileName (note: it will msgbox for each row in the file).
Connection Manager Setup:
Control Flow:
Foreach Loop Config:
DataFlow:
OLE DB Source:
Script Component:
Execution Results:
