I have a pretty simple sub-job that outputs to tMssqlOutput. One of my string fields contains carriage return/line feeds. These CR/LFs are being replaced with single spaces once they are inserted into the DB table. Yet, if I replace the tMssqlOutput with a tLogRow the CR/LFs are present (and correct).
I don't ever recall having this issue before. Any thoughts?
Thanks in advance!
Could you please elaborate your case with an example with input and expected output values?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.