title: Import text file data into SQL Server database
body: <p>I have a text file with below format</p>
  <p><a href="https://i.stack.imgur.com/j1zfa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/j1zfa.png" alt="enter image description here" /></a></p>
  <p>I want to import it in SQL Server database by splitting it into several columns:</p>
  <pre><code>Terminal, NetSales, NetAjustment, CancelsCnt, CancelAmount, 
  CashesCnt, CashesAmount, ClaimsCnt, ClaimsAmount, SalesCommission, 
  CashCommission, NetDue
  </code></pre>
  <p>I have tried to insert the text file in SQL Server using SSIS but its inserting everything in one column instead of split it, then used SQL scripting to split it into several columns but its not working</p>
  <p>I'm having some difficulties to split the column from the text file</p>
  <p>Any ideas or help about how I can capture those columns data into a proper format?</p>