How to overcome SSIS OData v4 date and time issues

MS SSIS does not recognise ‘Date’ or ‘Time’ type fields from an OData v4 source. To overcome this issue, Hubway has a feature that converts Date or Time types to DateTime type.

Hubway solves this problem with its “Cast Date and Time attributes as DateTime” feature.
Go to your Hubway Project → Project → Advanced Settings.
Turn on Cast Date to DateTime toggle on Hubway’s project to workaround the MS SSIS date conversion issue.

For more details: https://hubwayconnect.com/knowledge-base/cast-date-and-time-attribute-as-datetime/