tMssqlOutput and Carriage Return / Line Break

Six Stars

tMssqlOutput and Carriage Return / Line Break

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!


Re: tMssqlOutput and Carriage Return / Line Break


Could you please elaborate your case with an example with input and expected output values?

Best regards


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.


Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.