SSIS 2012 Lookup Transform converts date field to string (DT_WSTR)

We are using lookup transformation in SSIS 2012. The lookup transformation queries a table with two date columns. When we hover the mouse over the two columns in the 'columns' tab of the lookup transformation editor, the two columns show as DT_WSTR instead of DT_DBDATE. This causes the SSIS package to fail due to data type mismatch.

A similar abandoned thread is available at:

http://stackoverflow.com/questions/12391783/why-does-ssis-now-convert-sql-dates-to-dt-wstr

Please help.

July 29th, 2015 8:24pm
Convert using Derived Column Transformation for datatypes to match.
Free Windows Admin Tool Kit Click here and download it now
July 29th, 2015 10:11pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics