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!

Moderator

Re: tMssqlOutput and Carriage Return / Line Break

Hello,

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

Best regards

Sabrina

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads