How to fix the issue when i read a column from salesforce the line separated values are not copied.

Question

Hi ,

I have a pipeline thats running fine, but when its fetching data from Salesforce the line separated value is not considered

eg: in salesforce the value is :

order

akc

While copied in synapse it is : order

the line separated value akc is not read in synapse activity.

Answer 1

Hello Sri Akshara A,

Welcome to the MS Q&A platform.

One possible reason for this issue is that the line separator used in Salesforce is incompatible with the line separator used in Synapse.

To resolve this issue, you can try changing the line separator used in the Salesforce source data to match the line separator used in Synapse.

Please follow the below steps:

• Check the line separator: Ensure the Synapse activity recognizes the line separator used in Salesforce. The Synapse recognizes the following line separators: CRLF (carriage return, line feed), LF (line feed), and CR (carriage return). If the line separator used in Salesforce differs, you can try replacing it with one of these recognized separators.
• Use a data flow: Instead of using a copy activity, you can use a data flow to copy the data from Salesforce to Synapse. In the data flow, you can use a source transformation to read the data from Salesforce and a sink transformation to write the data to Synapse. The data flow can handle different line separators and convert them to the appropriate line separator recognized by Synapse.

I hope this helps. Please let me know if you have any further questions.