How to perform bulk insertion in SQL Server from dat file?
<p>My input data in <code>.dat</code> file looks like this:</p>

<pre><code> 1| 2| 3| 4| 5| 6 
11|22|33|44|55|66
</code></pre>

<p>up to 300 000 rows</p>

<p>Dat file contains 6 columns I need to add one default column and perform bulk insertion into SQL Server</p>

<p>How can I do it?</p>