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?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables