Shriwitha

Shriwitha

  • 2.1k
  • 2
  • 196

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

Feb 24 2021 9:42 PM
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,

Answers (2)