title: Fastest way to load flat file in ssis
body: <p>I have a single flat file which needs to be loaded in a SQL Server. For that I have to use SSIS. Now I want to know about things which can help me loading these files in the fastest way:</p>
  
  <ol>
  <li>Should I use Flat file manager or Script task to load the flat file? (<em>because in one of my <a href="https://stackoverflow.com/questions/11090632/how-to-add-progress-counter-in-ssis">question</a>, i got an answer which states that script task load things faster</em>)</li>
  <li>Destination (ADO.NET or SQL Server) ?</li>
  <li>Any other setting/Best Practice for flat file which I can make to load the file in faster way?</li>
  </ol>