title: SQL Server 2008 SSIS: Importing date field incorrectly (from Oracle)
body: <p>The date fields in the file (CSV) I must import are in the format <code>DD-MMM-YY</code>, SQL Server is importing them as <code>YY-MM-DD</code>. So <code>01-FEB-13</code> is imported as <code>2001-02-13</code>. </p>
  
  <p>How can I change the format SQL uses to import the dates?</p>
  
  <p>I don't have access to the original Oracle database, only the flat file exported from it. So everything I do pretty much has to be done in SQL.</p>