title: How can I insert into to a SQL Server database data from an online CSV?
body: <p>I need to perform a dataload every day from a csv available online e.g. <a href="http://www.supplier.com/products.csv" rel="nofollow">http://www.supplier.com/products.csv</a>
  Once I've dumped the csv into a sql table I can do the processing I then need to update / insert etc. The problem is that I don't know how to automate the dataload.</p>
  
  <p>I was hoping I could use a SQL job / task, scheduled to run each day at 06:00, give it a uri and that it could then access the data in the csv...</p>
  
  <p>How can I do that?</p>