title: Conversion error between "DT_DBTIME2" and "DT_WSTR" for "ETAHour"
body: <p>I have a SQL query that returns me a <code>"time(0)"</code>. I load that into SSIS, and it gets automatically converted to a <code>"DT_DBTIME2"</code>, which is okay. I can transform it to any other type without error using a data conversion data flow item.</p>
  
  <p>My problem is that when I try to insert that value into a <code>"time(0)"</code> field of a table, it gives me the following error:</p>
  
  <blockquote>
    <p>The OLE DB provider used by the OLE DB adapter cannot convert between
    types "DT_DBTIME2" and "DT_WSTR" for "ETAHour".</p>
  </blockquote>
  
  <p>When I mouse over the fields in the <code>OLE DB</code> Destination component, it clearly says that the source field is a <code>DT_DBTIME2</code> and the destination field is a <code>DT_DBTIME2</code>. I really wonder where this conversion error comes from. </p>