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/