title: SSIS heavy data import on Prod DB
body: <p>I need to import large amount of data around 1Mil rows from a CSV into my Prod DB table.
  My table has around 50 Mil rows, 20 columns(int, decimal cols), 6 indexes.
  What is the best approach to import this data using SSIS without taking down my DB or table?
  I will be importing this kind of data biweekly using the SSIS package, so the amount of data after a few months will be increasing in the table which could affect the import process.</p>