autodownload into SQL server for website

I want to set up a website that gets its data from a SQL server database. The SQL server needs to have its data updated automatically every 24hrs from a CSV file available from a financial website.
How do I go about:
1. Setting up the website to automatically download this CSV file at predefined times.
2. Getting the SQL databse to import the newly downloaded CSV file after the download is complete?
Thanks.