I have an Azure Data Factory pipeline with an xml file as a source. The target sink is an Oracle table containing a datetime column.
The mapping for most of the columns has been simple, as shown below:
My problem is mapping to "SupplyDate"
This needs to come from a source column with the following path:
I've tried using the "Add dynamic content" editor to wrap with the @formatDateTime function as follows:
But this gives an "Unrecognized expression" exception.
Where did I go wrong?
I've also experimented implementing using data flows but that won't let me select my target Oracle dataset.