title: bulk insert a date in YYYYMM format to date field in MS SQL table
body: <p>I have a large text file (more than 300 million records). There is a field containing date in YYYYMM format. Target field is of date type and I'm using MS SQL 2008 R2 server. Due to huge amount of data I'd prefer to use bulk insert. 
  Here's what I've already done:</p>
  
  <pre><code>bulk insert Tabela_5
  from 'c:\users\...\table5.csv'
  with
  (
      rowterminator = '\n',
      fieldterminator = ',',
      tablock
  )
  select * from Tabela_5
  </code></pre>
  
  <p><code>201206</code> in file turns out to be <code>2020-12-06</code> on server, whereas I'd like it to be <code>2012-06-01</code> (I don't care about the day).
  Is there a way to bulk insert date in such format to a field of date type?</p>
  
  <p>kind regards
  maciej pitucha</p>