title: Converting Oracle timestamp(6) to datetime
body: <p>I am pulling data in from an Oracle source (SSIS). After a week of successful run, a timestamp of '6/19/0002 12:00:00 AM' shows up. How do I convert this to SQL server datetime? I am fine with just setting this as null, but how do I detect invalid dates in ssis?</p>
  
  <p>SQL Server 2008/SSIS 2012</p>
  
  <p>I do not have control of Oralce source.</p>
  
  <p>Thanks</p>