SSIS packege to load CSV file in new sql table every time it runs.

Question

Hello,

I am new to SSIS.I need to create a SSIS package where CSV is the source file and SQL table is the destination.

Users place CSV file in a shared location once in a week, for every run (on a weekly basis) it needs to create a new dynamic SQL table in DB.Table name will be date extension along with the file name.

Can any one help me with the steps to achieve this?

Thanks in advance,