title: ETL SSIS : Redirecting error rows to a seperate table
body: <p>I am working on a package that contains a Source, about 80 lookups and 1 destination.</p>
  
  <p>The data in the source table is not consistent enough and hence my package fails very often.</p>
  
  <p>Is there a way by which I can transfer all the rows which are giving at the time of inserting them in destination table?</p>
  
  <p>For eg. I have 5 rows in Source and out of which 1st and 4th will give error. Now the result should be that 2nd, 3rd and 5th should go in destination but 1st and 4th should be stored in some flat file or a db table.</p>
  
  <p>Thanks in advance</p>