title: How to prevent SSIS from importing data from a file that already exist in database?
body: <p>Everyday i load some csv data into my table. And my table has date column, now i need to use rollback function, such that,  if the data already exists in my table it has to rollback, else it has to inserts based on my Asofdate parameter.  </p>
  
  <p>I know it is little confusing, let me be more clear.  </p>
  
  <p>my table has eid, ename, asofdate columns , now when i insert new file every day, it has to see whether that file is already existed in that table based on asofdate, if data exists, it should rollback the data.</p>