title: Is SSIS packages are best solution for importing and exporting the large amount of data?
body: <p>my requirement is that in nop commerce 1.9  i have to insert multiple discount form a excel sheet which have lot of data so before doing this task i need to be clear in mind which one is best solution for this.</p>
  
  <p><a href="https://stackoverflow.com/questions/5517229/which-is-the-fastest-way-to-upload-the-excelsheet-having-more-than-100-000-lines">Which is the fastest way to upload the excelsheet having more than 100,000 lines of code in C#?</a></p>
  
  <p>i read this question and answer found that <code>SSIS</code> is an option .</p>
  
  <p>is really <code>SSIS</code> is best for large size file import and export options. 
  and what other benefits i will get if i use <code>SSIS</code> packages ?</p>