Import a directory of dbf files to sql server

i'm trying to import dbf files using for each container in ssis. But i keep getting errors to map the files and other errors.

Here is what did.

1) Use for each container.

2) Use a data flow task in the container.

3) Use oledb source for visual foxpro (or jet ) and set expended properties as dbase iv and connection string as variable from expressions.

4) Use another variable for sql server table name, removing .dbf extension.

5) Use a sql oledb destination and set its table as table, view or variable name. Set the variable to created one in step 4.

As the sql server table is not there already how to create and import dynamically. There is lot of dbfs so looking for dynamic creation of the same and import.

Thanks.