Your advise on storage of CSV files

Hello,

We receive CSV files that follow the same structure every week. I want to automate the process of writing them to a SQL database.
What are best practises for this scenario to fully automate it? What would you do in this scenario?

Thank you