This has come up several times in the course of the last TWO jobs, so I’ll put it here for my reference (and yours).
To use a dBASE file as a source in SSIS (and I know you want to), in your new connection manager:
Create a new data flow source and use your OLE DB/Jet connection manager; your drop-down list of tables will display each DBF file in the folder. That is to say, each DBF file in the folder is considered a table. Easy! You know, once you know the trick.
Microsoft reference: How to: Connect to a dBASE or Other DBF File
Oh, P.S.! Sean will be at SQL Saturday 28 Baton Rouge this Saturday! There are still a few spots left, so go register and remember to be on #HairWatch!
ONE LAST P.S.! Remember to vot for the PASS Summit Community Choice sessions (specifically, Sean’s . Details here.