title: Move Records Which are older than 3 years from One Database (Production DB) to Another DB (Archive DB) Using SSIS
body: <p>Requirement is to Move Data Older than 3 years from Production DB to Archive DB , and Once Moved Delete those records from Production DB , so at any point of time Production DB will have only last three years of records.</p>
  
  <p>i want to achieve this by SSIS , i read quite a few articles about Data Archival but couldn't figure out the best Approch.</p>
  
  <p>I am New to SSIS</p>
  
  <p>i want to achieve exactly something like this (answer given in Below link)with extra condition saying move only those records which are older than 3 years and then delete those records.</p>
  
  <p><a href="https://dba.stackexchange.com/questions/25867/moving-data-from-one-db-to-another-using-ssis">https://dba.stackexchange.com/questions/25867/moving-data-from-one-db-to-another-using-ssis</a></p>
  
  <p>Criteria for an accepted answer answer should address </p>
  
  <ul>
  <li>scalability</li>
  <li>complexity</li>
  <li>failure handling</li>
  <li>reliability</li>
  </ul>