title: Bulk upload million records to DB from Excel sheet
body: <p>I have a task where user upload excel file having million records from UI and I need to validate the data and if everything is correct, it will upload all million records at single shot(bulk upload) to SQL DB. </p>
  
  <p>I have been analyzing the approach how it has to be done. I get only 2 ways. </p>
  
  <p>One is through UI where user uploads excel sheet and do validate check and sqlbulkcopy to Database. And the second one where user uploads the excel from UI and I will save that file in some folder and creates a SSIS package to it and run the job scheduler to run that job from the backend.</p>
  
  <p>I know later one will work as we ruuning through SSIS package. But User only gets their out put when and only job runs. But My requirement needs instant output to the user whenever he uploads the application from UI. For that I should go with former. With this option I was wondering UI couldn't handle to insert million records at bulk from excel sheet. </p>
  
  <p>Can some one tell me how should I move forward or What would be the best way to implement.</p>