title: Converting text to date format SSIS
body: <p>I am using SSIS to import data from Excel to SQL Server database. </p>
  
  <p>The date column has <code>nvarchar</code> data type, and I want to change it to a date data type <code>YYYY-MM-DD</code>.</p>
  
  <p>If the value is null then I want to get null. </p>
  
  <p>I used <code>[mycolumn]</code> date,  on the create a new table option on the OLE DB destination.</p>
  
  <p>Is that right?</p>