We have a requirement to load data into Salesforce custom table daily and before load it has to be truncated.
We are not able to get any option for table/api truncation in Data services designer.
Could you please help if there is any way to achei...
Hi Experts,
I am trying to write/load decimal data type data into .csv files and Salesforce tables/api using data services 4.2 SP 10.
Data services converting the decimal field value from decimal point to comma resulting in following situ...
Hi Victor,Hope you would have resolved the issue.I am also facing the same one and not able to fix it.Could you please help if it was resolved.Thanks,Kamlesh
Thanks Sandesh for your response.Would it be possible for you to guide on how you handled it using batch script?Like copied files from SFTP location to your local location and consumed it or directly consumed it from SFTP location.Any pointer on the ...
Hi Sandesh,I am also having the same scenario to be handled in my project.Just wanted to check if you have got any solution to handle the multiple directories using same file location object by parameterizing it through Global variables?Thanks,Kamles...
Hi Dirk,Thanks for the clarification.So, if my understanding is correct then we can't use an IN operator under where clause for non-database type data store, which has values getting passed through a Variable.Regards,Kamlesh Arya
Hi Akhilesh,Thanks for your suggestion.The problem is not about converting any value to decimal. The field values are already of decimal type, which Data services is implicitly converting to comma(,) while loading into Target causing failure and wron...