title: How to optmize ssis package when data is huge
body: <p>I have a table TABLE_SRC having 3 million records and 20 columns in one of the SQL server DB 
   I want to load data in same structure table TABLE_DEST in a different server and  in SQL server DB 
   I just created one oledb source that would pull data from TABLE_SRC and then use oledbcommand to delete existing data from TABLE_DEST
   and then use oledbdestination to map and load data from TABLE_SRC to TABLE_DEST.</p>
  
  <p>But this process is taking too much of time, as data is huge I understand that it would take time but can I optimize or use some best practices to load data in this case. </p>