title: SQL Server Import and Export Wizard Datetime issue
body: <p>I need to import a flat csv file with datetime column - 'ExecutionDateTime'. This column can have empty values, example : </p>
  
  <p><a href="https://i.stack.imgur.com/7dp9O.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7dp9O.png" alt="enter image description here"></a></p>
  
  <p>I am  importing this to an existing table with ExecutionDateTime Column is set as Datetime2.</p>
  
  <pre><code>ExecutionDateTime   datetime2,
  </code></pre>
  
  <p>When I import using SQL Server Import Export wizard, I get value as "<strong>0001-01-01 00:00:00.0000000</strong>", for the empty row. I want it to Read NULL. </p>
  
  <p>ExecutionDateTime Column is set as Datetime2. </p>
  
  <p>Current behavior: </p>
  
  <p><a href="https://i.stack.imgur.com/5CwvW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5CwvW.png" alt="enter image description here"></a></p>
  
  <p>Expected :</p>
  
  <p><a href="https://i.stack.imgur.com/HWnch.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HWnch.png" alt="enter image description here"></a>
  Is this possible? </p>
  
  <p>I am using SQL Server 2012. </p>
  
  <p>Any pointers? </p>