title: Convert SQL Server DATETIMEOFFSET to mySQL DateTime
body: <p>I've been tasked to write an SSIS package to convert several SQL Server databases to mySQL and my current issue issue is with the DATETIMEOFFSET datatype from SQL Server.
  I've tried casting the field, I've tried converting it and I've tried casting it <em>then</em> converting it to a DATETIME datatype but no luck.  But everything I've tried has resulted in this error:</p>
  
  <blockquote>
    <p>[ADO NET Destination [2]] Error: An exception has occurred during data insertion, the message returned from the provider is: ERROR [07006] [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.10]Conversion is not supported</p>
  </blockquote>
  
  <p>Any ideas on how to get this sql server datatype into mySql?</p>