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,