Hi @sam nick ,
Thanks for reaching out.
As per the error message, it looks like you are trying to convert a
TimeSpan data type to
DateTime datatype. And as per the ADF documentation below are supported Data type mapping for Salesforce and I don't see a
TimeSpan datatype called out. Hence assuming it is not supported and which is why you are receiving this error.
Unfortunately this is ADF's limitation, Product team suggest customers to consider changing the Salesforce type (
TimeSpan) of that column to the one that is supported by ADF's Salesforce connector. Please refer to this doc for a list of supported Data type mapping for Salesforce : Data type mapping for Salesforce
If possible try to convert your source column data type to one of ADF supported Data types for Salesforce.
Additional info: Also please refer to this stackoverflow thread which has a discussion about why it is not possible to convert
TimeSpan to a
DateTime : https://stackoverflow.com/questions/10276228/timespan-to-datetime-conversion
Hope this info helps.
Please don’t forget to
Accept Answer and
Up-Vote wherever the information provided helps you, this can be beneficial to other community members.
Hi @sam nick ,
We still have not heard back from you. Just wanted to check if the below suggestion was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.