title: SQL Unique Update
body: <p>I have a file that updates every 15 min with sales data. The files is MTD and as of 8 AM it is finalized every day. Its a flat text CSV written to a SP every 15 min. This being said I would like to add the entries to a SQL data based for long term storage. The problem is if I keep adding the table I continue to get duplicates. There are a maximum of 1500 entries per day. I am really new to SQL so the simplest solution would be preferred over potential performance loss until I get some SQL under my wings. </p>
  
  <p>I have SQL 2014 and SSIS. Any pointers or help would be greatly appreciated. I read a few of the other posts but nothing that I could find helped this specific issue. </p>
  
  <p>How can I do this?</p>