Hello,
Has anybody successfully managed to call a BC OData endpoint using an SSIS source component if the endpoint includes a Datetime column with only a date element?
If I set up a Query object on the Item table with the following field:
column(LastDateModified;"Last Date Modified")
{
Caption = 'Last Date Modified';
} //#62
And expose it a web service - and then call it in SSIS I get the following error:
TITLE: System.Data
------------------------------
Unable to cast object of type 'Microsoft.OData.Edm.Library.Date' to type 'System.IConvertible'.Couldn't store <2019-10-25> in LastDateModified Column. Expected type is DateTime.
------------------------------
ADDITIONAL INFORMATION:
Unable to cast object of type 'Microsoft.OData.Edm.Library.Date' to type 'System.IConvertible'. (System.Data)
Now it is a DateTime but only with the date element (and another below with only the time element). But for some reason the OData metadata is expecting a Date field.
The annoying this is that if fails at the OData component - i.e., I don't even have the chance to pass it through another component like a conversion or derived column.
I'm trying to avoid having to write c# script tasks for what should be a fairly simple requirement.
Any help much appreciated.
