31 March 2020
We have checked your package "sandbox connection". As we can see, you are using:
1) Filter for the source data: Date equals TODAY.
This filter is correct in case if you need to perform source data only if the column Date equals TODAY.
Regarding filters please see:
2) Expression mapping for the Date field: "TODAY"
This Expression is incorrect, please remove it. Expression mapping does perform any filtering. The mapping settings indicate what values are sent to the target fields.
You can use Column mapping here and map the target Date field to the source Date column. Regarding mapping please check: